On-site & Public, Instructor-led, Hands-on IT Training
(International 01) 908.233.8900
  400+ Course Offerings:

Search for Course:

DB1035 Advanced Query Tuning with Optimization Service Center
Duration3 Days
Delivery MethodInstructor Led, Hands-on Workshops
Public Price$1625.00

DESCRIPTION (Return to Top)

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.

AUDIENCE (Return to Top)

Application Architects, analysts, developers and DBAs involved in the development and support of DB2/SQL applications.

OBJECTIVES (Return to Top)

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 (Return to Top)
  • 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)


A basic understanding of SQL optimization is helpful.