This course covers all aspects of Db2 performance & tuning. Over four days, we cover keys to indexing, table design, monitoring application performance, system monitoring and tuning, buffer pool and memory allocation. This class uses hands-on and paper exercises to reinforce the topics covered. This class is current to DB2 11.5 and new fix packs.
This is not an introductory Db2 class. Students should be senior enough to be Db2 DBAs or senior application staff, or have experience with another DBMS.
4 Days/Lecture & Lab
This course is designed for database administrators, systems personnel and senior development staff.
- Table space and table design topics
- Index design
- Access path selection topics
- Object Management
- Advanced SQL Topics
- Table Space Design
- Index Design
- Access Path Selection
- Evaluating SQL Performance
- Locking and concurrency
- Key System Parameters
- Buffer Pool Optimization Techniques
- Database and Db2 System monitoring