Loading Course Schedule...
PT24807
Training Summary
This course covers all aspects of Db2 performance & tuning. Over four days, we cover system monitoring and tuning, buffer pool and memory allocation, keys to indexing, table design and monitor application performance. This class uses hands-on and paper exercises to reinforce the topics covered.
Prerequisites
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
Duration
4 Days/Lecture & Lab
Audience
This course is designed for Database administrators, systems personnel and senior development staff.
Course Topics
- Object Management
- Key System Parameters
- Buffer Pool Optimization Techniques
- Database and Db2 System monitoring
- Table Space Design
- Locking and concurrency
- Index Design
- Access Path Selection
- Evaluating SQL Performance