About Trainer

  • 11 years of DB2 experience
  • 2 years of onsite experience
  • Teaching DB2 from 5 years
  • IBM DB2 LUW Certified
  • Working as an Architect
  • Excellent in Communication

About IBM DB2 LUW UDB

 
 
 
 
ONLINE TRAINING IN IBM DB2 UDB/LUW DBA BY OUR REALTIME/CERTIFIED PROFESSIONALS

Course Pre-requisites:
Duration: 32 Hours
Cost: USD 350

Lab setup: RHEL 32/64 bit

Training Material:

  • Class PPT’s (Soft Copy)
  • Class recordings (optional)

IBM DB2 LUW/UDB DBA Course Outline

  • Overview of DB2 on Linux, UNIX and Windows
  • Command Line Processor (CLP) and GUI usage
  • Database Manager Instance
  • Creating databases and data placement
  • Creating database objects
  • Moving data
  • Backup and recovery
  • Database Maintenance, Monitoring and Problem Determination
  • Locking and concurrency
  • Security
  • Log Management
  • Performance Tuning
  • Advanced Monitoring
  • High Availability with DB2 database products

Contents

Unit 1: Overview of DB2 on Linux, UNIX and Windows (1 hour)

  • DB2 family products overview (LUW, Mainframe, iSeries)
  • DB2 LUW product editions (Express-c to PureScale to InfoSphere)
  • DB2 product features and functions
  • DB2 client connectivity options (Data Studio, Data Server Client)

Unit 2: Command Line Processor (CLP) and GUI usage (1 hour)

  • Introduction to DB2 CLP environment
  • Non-interactive mode
  • Interactive mode
  • db2 command line options
  • Client connectivity from Data Studio

Unit 3: The DB2 Database Manager Instance (3 hours)

  • About DB2 Instance
  • Database Manager Instance overview
  • DB2 instance creation pre-requisites
  • Create and Drop an instance
  • Starting and Stopping an instance
  • list and modify DBM configuration
  • db2set command
  • db2 history command
  • DB2 registry and environment variables
  • Exercise 1: Product installation, extract and instance creation

Unit 4: Creating databases and data placement (4 hours)

  • Database creation pre-requisites
  • Database storage requirements
  • Table spaces overview
  • Storage management overview (SMS, DMS, Automatic)
  • Default Table spaces
  • CREATE DATABASE command
  • List DB configuration parameters
  • Modify DB configuration parameters
  • Database directories and files introduction
  • System catalog tables and views
  • Containers, extents, pages overview
  • CREATE TABLESPACE syntax
  • Storage groups overview
  • CREATE STOGROUP syntax
  • Assigning a tablespace to a storage group
  • Introduction to db2pd command
  • ALTER TABLESPACE, ALTER STOGROUP
  • DB2 LIST DB DIRECTORY
  • DB2 LIST NODE DIRECTORY
  • Activate and deactivate a database
  • Exercise 2: Creating databases and data placement

Unit 5: Creating database objects (2 hours)

  • DB2 object hierarchy
  • CREATE SCHEMA
  • CREATE TABLE, VIEW
  • CREATE ALIAS, INDEX, TRIGGER
  • creation of temporary tables
  • Creation of temporal tables
  • Table partitioning
  • Referential Integrity
  • Keys, Constraints
  • db2look CLI command
  • Authorization & Authentication
  • Exercise 3: Creation of table spaces, tables, databases

Unit 6: Moving data (3 hours)
  • IMPORT versus LOAD
  • Offline versus online load
  • LOAD QUERY TABLE
  • DB2 LIST UTILITIES
  • Pending states (Load, backup, set integrity)
  • EXPORT command
  • db2move cli command
  • ADMIN_MOV_TABLE procedure
  • Exercise 4: Moving data using Export, Import, Load

Unit 7: Backup and recovery (3 hours)

  • Transactional logging (Circular, Archival)
  • Configure database logs
  • Backup utility options
  • Recovery utility options
  • ROLLFORWARD
  • DB2 RECOVER DATABASE
  • ONLINE versus OFFLINE backup
  • Exercise 5: Backup and recovery

Unit 8: Database Maintenance, Monitoring and Problem Determination (3 hours)

  • RUNSTATS utility
  • REORGCHK utility
  • REORG Utility
  • DB2 List commands
  • db2pd - Monitory and troubleshoot DB2
  • MON_GET_TABLE function
  • CREATE EVENT MONITOR
  • DB2 Optimizer
  • DB2 EXPLAIN
  • db2diag.log diagnostic log
  • db2trc command to obtain trace
  • db2fodc: collect diagnostic data for system hang
  • db2advis: Analyze workload
  • Exercise 6: Using above DB2 Tools/Utilities

Unit 9: Locking and concurrency (2 hours)

  • Importance of locking
  • Table lock modes
  • Row lock modes
  • Lock mode compatibility
  • Isolation levels
  • LOCK TABLE statement
  • Lock escalation, wait, and timeout
  • Deadlocks and detection
  • Exercise 7: using db2pd to identify locks, wait locks, deadlocks

Unit 10: Security (1 hour)

  • Authentication versus Authorization
  • SYSADM, SYSCTRL, SYSMAINT, SYSMON
  • DBADM, SECADM, ACCESSCTRL
  • DB2 security privilege hierarchies
  • Grant and Revoke privileges
  • Exercise 8: Database Security using grant/revoke

Unit 11: Log Management (2 hours)

  • Database seeds
  • Log sequence numbers
  • db2ckbkp -l command
  • logfilsiz, logbufsz
  • Logprimary and Logsecond
  • db2pd to check logging activity
  • Log Archive processing
  • Log retrieval processing
  • MAX_LOG configuration parameter
  • Exercise 9: Log archive/retrieval process

Unit 12: Performance Tuning (3 hours)

  • Analyze SQL statements
  • Create an access plan graph
  • db2exfmt tool
  • db2expln tool
  • Using Indexes for performance
  • Index usage statistics using db2pd
  • MON_GET_INDEX
  • MON_CONNECTION_SUMMARY view
  • Clustering indexes
  • db2advis command
  • Exercise 10: Explain Tools, Indexes creation

Unit 13: Advanced Monitoring (2 hours)

  • GET SNAPSHOT command
  • In-memory metrics
  • Monitoring table functions
  • Administrative views, functions
  • Monitoring performance with SQL
  • Monitor heath with SQL
  • Exercise 11: In memory metrics, SQLS, Admin views, functions

Unit 14: High Availability with DB2 Database products (2 Hours)

  • High Availability options in DB2
  • DR options in DB2
  • High Availability Disaster Recovery (HADR)
  • High Availability through Log Shipping
  • Log mirroring
  • High Availability through suspended I/O and online split mirror support
  • Exercise 12: DB2 HADR setup (1 primary, 1 standby creation, setup, communication

 
 
 
 

Testimonials

  • The fact that they have a set format of teaching, which creates a schedule for a student, and a step-by-step process that covers the entire Netezza syllabus. I can surely assure eTraining provides a great help for Netezza curriculum.
    - Shannon D.

  • The BEST I liked about the tutors in eTraining is the amount of practical knowledge these guys have and the way they bring in the same to students perspective while Teaching. Glad I took DB2 course from eTraining.
    - Rubeena Khan

  • I found classes very helpful. What you Teach is AWESOME
    - Gopal

  • A great value for time and money. The BEST Training I have received so far from India
    - Susan, DBA Lead