Db2 for LUW System Performance & Tuning

Catalog Home IBM Mainframe, Midrange & ISV Products Db2 for z/OS
Your Training Location:  

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

< >

Copyright © 2020 ProTech. All Rights Reserved.

Sign In Create Account


Social Media