Course Duration: 1 month (40 hours of theory and 40 hours of practical)

Course Content:

Unit #1: Db2 Server Management

  1. Configuring and Working with Db2 instances and databases
  2. DB2 autonomics and automatic storage features
  3. Using configuration advisor
  4. Taking control of the database
  5. Performing administration tasks using IBM Data Studio
  6. Scheduling database jobs
  7. Hands on Lab – 20 exercises

Unit #2: Db2 Database Physical Design

  1. Designing a database – all about server infrastructure
  2. Designing a database instance
  3. Designing a database
  4. Physical database design
  5. Designing Storage Groups and Multi-temperature storage
  6. Designing LOB and Full Text Search data place holders
  7. Table Design Concepts – Range Partitioning and Range Clustered
  8. Designing Time Travel Query tables
  9. Designing Views and Stored Procedures
  10. Designing Concurrency and Security
  11. Hands on Lab – 20 exercises

Unit #3: Business Rules Implementation

  1. Understanding Business Rules
  2. Understanding Constraints
  3. Creating Constraints and Performing Set Integrity
  4. Understanding Check Options
  5. Creating triggers and discussions on practical usage
  6. Hands on Lab – 10 exercises

Unit #4: Db2 Monitoring

  1. Understanding Db2 Monitoring Elements
  2. Database Monitoring using – snapshots, table functions and admin views
  3. Working with event monitors
  4. Analyzing Expensive SQL Statement
  5. Understanding Db2 trouble shooting tools
  6. Monitoring Multiple Database Elements
    1. Table Space
    2. Storage Groups
    3. Lock waits
    4. Resource Usage and Wait times
    5. Expensive SQL statements
  7. Comprehensive use of db2pd and dsmtop (db2top replacement) tool
  8. Hands on Lab – 20 exercises

Unit #5: Db2 Utilities

  1. Data Movement Utilities and File Formats
  2. Working with EXPORT, IMPORT, LOAD
  3. Understanding phases of Db2 Load operation
  4. Loading XML, LOB and JSON data
  5. Data Loading Methods
  6. Working with Db2 ingest utility
  7. Comparing Load, Import and Ingest
  8. Migrating database from and between AIX, Linux and Windows
  9. Working with database maintenance utilities – REORG, RUNSTATS and REORGCHK
  10. Working with performance utilities – db2batch, advanced design advisor
  11. Hands on Lab – 20 exercises

Unit #6: Db2 High Availability and Disaster Recovery

  1. Understanding transactions and transaction logging
  2. Understanding Db2 database recovery concepts
  3. Working with Db2 backup – online, offline, full, incremental and delta
  4. Understanding and working hands on with Db2 High Availability and Disaster Recovery (HADR)
  5. Setting up multiple HADR standbys
  6. Setting and working with HADR Read On Standby (RoS) feature
  7. Understanding basics of DB2 pureScale
  8. Hands on Lab – 20 exercises

Unit #7: Db2 Security

  1. Understanding Db2 security
  2. Working with authentication and authorization
  3. Implementing Row and Column Access Control (RCAC)
  4. Implementing DB2 column masks
  5. Implementing Label Based Access Control (LBAC)
  6. Using DB2AUDIT
  7. Hands on Lab – 8 exercises

Unit #8: Db2 Connections

  1. Understanding and configuring Db2 server communication
  2. Understanding and creating catalogs
  3. Configuring LDAP connections
  4. Troubleshooting communication problems
  5. Hands on Lab – 8 exercises

Unit #9: Db2 BLU

  1. Understanding the BLU technology
  2. Deep dive into BLU
  3. Understanding and creating shadow tables
  4. Converting row tables to column
  5. Reclaiming deleted space in BLU (column organized) tables
  6. Hands on Lab – 8 exercises