This is the Classroom version of Instructor-led Online course DB2 9 for z/OS Application Performance and Tuning - ILO. This course is designed to teach you how to prevent application performance problems and to improve the performance of existing applications.
DB2 10 for z/OS Application Performance and Tuning
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.
You should have:
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 **
Locking Issues** Machine Exercise 6 - Locking Issues **
Face-to-face learning in the comfort of our quality nationwide centres, with free refreshments and Wi-Fi.
Find dates and prices
Online booking is currently not available for this course, to find out more please call us on 0113 220 7150 or email us at firstname.lastname@example.org to discuss how we can help.
Fully accredited to ensure we provide the highest possible standards in learning