Db2 for LUW System Performance & Tuning

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. This class is current to Db2 11.1 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.
  • 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

Related Scheduled Courses