Articles & Content


Pro-actively health checking queries and tuning, is there a doctor in the house? (E16)

Topic: 2010 EMEA

Subtopic: DB2 for z/OS

DATE: 2010-11-11 (09:45 - 10:45)
SPEAKERS: Kurt Struyf (competence partners)

Would you like to health check your query and index design, with minimal effort? Would you like to start tuning as early as development, at low cost? This presentation will show you how to do this. In a matter of a few very simple ‚ úin-DB2‚ ? techniques, you will be able to detect non-performing SQL and indexes to be improved. The big mystery? The extra explain tables ! You can use the data of all of the explain tables (plan_table, dsn_predicate, dsn_sortkey‚ ¶), and turn it into a performance benefit for your company. This presentation shows you how to use this information, with minimal effort, so you can start tuning like a professional

EXP. LEVEL: Beginner,Intermediate


1. Overview of indexable, stage1 and stage2

2. Explaining the extra explain tables

3. How to find bad SQL patterns?

4. How to find poor index design?

5. How to fix bad SQL and poor indexes?

This file is being provided by IDUG. We would encourage you to join IDUG to get full access to all of our files and resources. Joining IDUG is FREE and signing up is simple. Click here to join! or login!

Download File
Click to Download

NOTE: These are only open to members of IDUG. If you are not a member, please CLICK HERE for more information.