This course is designed for the DB2 for z/OS development professional who desires to understand the fundamental issues associated with performance for DB2 SQL applications. Emphasis is placed on new considerations for DB2 Version 8 & 9 and the use of Optimization Service Center (OSC) as an optimization tool. Concepts discussed will be reinforced with appropriate workshops.
Application Architects, analysts, developers and DBAs involved in the development and support of DB2/SQL applications.
Upon completion of this course the student should understand:
- When different types of access paths are desirable
- The new statistics available in DB2 Version 8 & 9 and their impact on access path selection
- New optimization techniques available with the DB2 9 optimizer
- How to use the information provided by OSC to improve the performance of DB2 applications
A basic understanding of SQL optimization is helpful.