DESCRIPTION
This 1 day 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 the use of Optimization Service Center (OSC) as an optimization tool.
AUDIENCE
Application Architects, analysts, developers and DBAs involved in the development and support of DB2/SQL applications.
OBJECTIVES
Upon completion of this course the student should understand:
- When different types of access paths are desirable
- New optimization techniques available with the DB2 9 optimizer
- How to use the information provided by OSC to improve the performance of DB2 applications
TOPICS
- Optimization Goals & Tools
- Access Paths with OSC
- Case Studies in Optimizer Problems
- OSC In-Depth
PREREQUISITES
A basic understanding of SQL optimization is helpful.
