Loading Course Schedule...
PT25931
Training Summary
Meeting performance objectives is a key priority for the Db2 database and systems administrators. Db2 for z/OS database performance is best achieved by first establishing performance requirements and planning for performance monitoring. Our workshops assist in identifying critical performance bottlenecks, implementing performance tuning techniques and reviewing tuning results. We provide detailed guidance information for all personnel who will be participating in database performance in both a data sharing and non-data sharing environment.
Prerequisites
Db2 for z/OS Database Administration or equivalent experience and a working knowledge of SQL.
Duration
3 Days/Lecture & Lab
Audience
Db2 Database and System Administrators who will be monitoring and tuning Db2 for z/OS Databases.
Course Topics
- Performance Overview
- Performance Analysis
- SQL Performance Tuning using EXPLAIN
- Application Performance Tuning
- Maintaining Statistics
- Database Performance Tuning
- Extended Features Performance and Tuning
- System Performance Tuning