Course Duration: 1 month (40 hours of theory and 40 hours of practical)
Course Content:
Unit #1: Db2 Server Management
- Configuring and Working with Db2 instances and databases
- DB2 autonomics and automatic storage features
- Using configuration advisor
- Taking control of the database
- Performing administration tasks using IBM Data Studio
- Scheduling database jobs
- Hands on Lab – 20 exercises
Unit #2: Db2 Database Physical Design
- Designing a database – all about server infrastructure
- Designing a database instance
- Designing a database
- Physical database design
- Designing Storage Groups and Multi-temperature storage
- Designing LOB and Full Text Search data place holders
- Table Design Concepts – Range Partitioning and Range Clustered
- Designing Time Travel Query tables
- Designing Views and Stored Procedures
- Designing Concurrency and Security
- Hands on Lab – 20 exercises
Unit #3: Business Rules Implementation
- Understanding Business Rules
- Understanding Constraints
- Creating Constraints and Performing Set Integrity
- Understanding Check Options
- Creating triggers and discussions on practical usage
- Hands on Lab – 10 exercises
Unit #4: Db2 Monitoring
- Understanding Db2 Monitoring Elements
- Database Monitoring using – snapshots, table functions and admin views
- Working with event monitors
- Analyzing Expensive SQL Statement
- Understanding Db2 trouble shooting tools
- Monitoring Multiple Database Elements
- Table Space
- Storage Groups
- Lock waits
- Resource Usage and Wait times
- Expensive SQL statements
- Comprehensive use of db2pd and dsmtop (db2top replacement) tool
- Hands on Lab – 20 exercises
Unit #5: Db2 Utilities
- Data Movement Utilities and File Formats
- Working with EXPORT, IMPORT, LOAD
- Understanding phases of Db2 Load operation
- Loading XML, LOB and JSON data
- Data Loading Methods
- Working with Db2 ingest utility
- Comparing Load, Import and Ingest
- Migrating database from and between AIX, Linux and Windows
- Working with database maintenance utilities – REORG, RUNSTATS and REORGCHK
- Working with performance utilities – db2batch, advanced design advisor
- Hands on Lab – 20 exercises
Unit #6: Db2 High Availability and Disaster Recovery
- Understanding transactions and transaction logging
- Understanding Db2 database recovery concepts
- Working with Db2 backup – online, offline, full, incremental and delta
- Understanding and working hands on with Db2 High Availability and Disaster Recovery (HADR)
- Setting up multiple HADR standbys
- Setting and working with HADR Read On Standby (RoS) feature
- Understanding basics of DB2 pureScale
- Hands on Lab – 20 exercises
Unit #7: Db2 Security
- Understanding Db2 security
- Working with authentication and authorization
- Implementing Row and Column Access Control (RCAC)
- Implementing DB2 column masks
- Implementing Label Based Access Control (LBAC)
- Using DB2AUDIT
- Hands on Lab – 8 exercises
Unit #8: Db2 Connections
- Understanding and configuring Db2 server communication
- Understanding and creating catalogs
- Configuring LDAP connections
- Troubleshooting communication problems
- Hands on Lab – 8 exercises
Unit #9: Db2 BLU
- Understanding the BLU technology
- Deep dive into BLU
- Understanding and creating shadow tables
- Converting row tables to column
- Reclaiming deleted space in BLU (column organized) tables
- Hands on Lab – 8 exercises