DESCRIPTION
This 3 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 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.
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
- 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
TOPICS
- Optimization Goals & Tools
- Access Paths with OSC
- Filter Factors & Performance
- Predicates Types
- Case Studies in Optimizer Problems
- Design for Performance
- OSC In-Depth
- Top 35+ Tuning Tips for DB2 SQL Developers (and More)
PREREQUISITES
A basic understanding of SQL optimization is helpful.
