DB2 for z/OS Data Sharing Performance and Tuning

    

Summary:
This course covers all aspects of DB2 for z/OS data sharing performance, from the hardware and software components of the DB2 data sharing group and the z/OS parallel sysplex that most affect performance, to performance-enhancing application programming techniques, to the tools available for data sharing performance monitoring and the rules of thumb that facilitate effective use of these tools. Knowledge transfer is enhanced through the use of paper-based lab exercises that involve analysis of configuration and monitoring reports drawn from real-world, production DB2 data sharing installations.

Duration:
4 Days/Lecture & Lab

Audience:
This course is intended for experienced DB2 professionals who are involved in DB2 data sharing support from a performance monitoring and tuning perspective.

Topics:

• z/OS Support Services
• Tuning z/OS Support Services
• DB2 Data Sharing Mechanics – GBPs
• DB2 Data Sharing Mechanics – Locking and the SCA
• Structure Tuning – GBPs
• Structure Tuning – Lock, SCA, and XCF
• DB2 Subsystem Tuning
• Application Tuning
• Tuning and Monitoring Your Data Sharing system – Putting it All Together

Prerequisites:
Students should be familiar with the DB2 for z/OS mainframe environment, ideally with production experience with DB2 for z/OS Version 7 or beyond.

Last Update: May 21, 2013