About this Course

Code TPZL1_CV962
Duration 5 Days

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.


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 **

Massive Batch

Locking Issues

** Machine Exercise 6 - Locking Issues **

5 Days

Training delivered by an IBM Global Training Provider
Delivery Method

Delivery method


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 info@qa.com to discuss how we can help.

Trusted, awarded and accredited

Fully accredited to ensure we provide the highest possible standards in learning

All third party trademark rights acknowledged.