Advanced Query Tuning with IBM Data Studio on Db2 for z/OS

Catalog Home IBM Mainframe, Midrange & ISV Products Db2 for z/OS
Your Training Location:  

Advanced Query Tuning with IBM Data Studio on Db2 for z/OS

Instructor Led
Loading Course Dates...
No available dates in this city.

  Available by Request
{{date.date_begin | date:'M/d'}} - {{date.date_end | date:'M/d/yyyy'}}
ViewHide Additional Dates

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. This class covers optimization features and enhancements through V11. There are many hands on workshops during these 3 days where students are coding, explaining, and analyzing SQL statements. Students will come out of this class much stronger in the SQL language and Db2 optimization. Many times there are 2, 3, 4, 5 different ways to code SQL statements in getting the same result. Which way is best? These are discussed in great detail with Db2 explains to back them up. Of course ‘It Depends’!

A basic understanding of the SQL language is helpful.

3 Days/Lecture & Lab

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

  • 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

< >

Copyright © 2021 ProTech Professional Technical Services, Inc. All Rights Reserved.

Sign In Create Account


Social Media