|Listepris||Set by Partner|
This is the Classroom version of Instructor-led Online course DB2 9 for z/OS Application Performance and Tuning - ILO (3V962NO).
This course is designed to teach you how to prevent application performance problems and to improve the performance of existing applications.
This advanced course is for DB2 for z/OS application developers, DB2 for z/OS DBAs and anyone else with a responsibility for application performance and tuning in a DB2 for z/OS environment.
Introduction to Application Performance and Tuning
Performance Analysis Tools
Towards Better Indexes
** Machine Exercise 1 - Designing Indexes **
Multiple Table Access
** Machine Exercise 2 - Subqueries **
Towards Better Tables
** Machine Exercise 3 - MQTs and Denormalized Tables **
Learning to Live with the Optimizer
** Machine Exercise 4 - NonIndexable and NonBoolean Predicates **
** Machine Exercise 5 - Helping the Optimizer **
** Machine Exercise 6 - Locking Issues **
Components of CPU Time