Audience
Db2 Database and System Administrators who will be monitoring and tuning Db2 for z/OS Databases.
Description
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.
Objectives
Upon successful completion of this course, the student will be able to:
- Develop a Performance Monitoring Strategy
- Reduce overall CPU consumption
- Reduce overall lock contention problems
- Improve overall application response times
- Identify and tune I/O overhead
Prerequisites
DB3010 Db2 for z/OS Database Administration or equivalent experience and a working knowledge of SQL.