DB2 11 for z/OS Application Performance and Tuning
DB2 11 for z/OS Application Performance and Tuning Course Details:
In this course, you will learn how to prevent application performance problems and improve the performance of existing applications. You will learn about indexes, table design, locking, and other issues relevant to application performance. This course includes paper exercises and machine exercises designed to reinforce the lecture content.
Note: While class exercises are performed within a DB2 11 for z/OS environment, our expert instructors can provide guidance on all versions and their differences.
*Please Note: Course Outline is subject to change without notice. Exact course outline will be provided at time of registration.
- Design better indexes
- Determine how to live with the optimizer (avoid pitfalls, help when necessary)
- Avoid locking problems
- Use accounting trace information to find significant performance problems in an operational application
Familiarity with DB2 for z/OS application programming and SQL.
This intermediate course is designed for DB2 for z/OS application developers, DB2 for z/OS DBAs, and anyone else who is responsible for application performance and tuning in a DB2 for z/OS environment.