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

Search for Course:

DB1037 Advanced Query Tuning with IBM Data Studio on DB2 for z/OS
Duration3 Days
Delivery MethodInstructor led, Hands-on workshops
Public Price$1800.00

DESCRIPTION (Return to Top)

Get ready for a deep dive into DB2 for z/OS Optimization. This course is for the DB2 for z/OS development professional who desires to understand the fundamental issues associated with performance for SQL applications. Emphasis is placed on new considerations for the latest releases of DB2 and the use of IBM Data Studio 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 successful completion of this course, the student will be able to understand:

  • When different types of access paths are desirable
  • The new statistics available in the latest releases of DB2 and their impact on access path selection
  • New optimization techniques available with the DB2 9 optimizer
  • How to use the information provided by IBM Data Studio to improve the performance of DB2 applications

TOPICS (Return to Top)
  • Optimization Goals & Tools
  • Access Paths with IBM Data Studio
  • Filter Factors & Performance
  • Predicate Types
  • Case Studies in Optimizer Problems
  • Design for Performance
  • IBM Data Studio Features
  • Top 35+ Tuning Tips for DB2 SQL Developers (and More)


A basic understanding of SQL optimization is helpful.