Db2 for LUW System Performance & Tuning

PT24807
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. This class is current to Db2 11.1 and new fix packs.
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.
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

Related Scheduled Courses