Articles & Content


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

Topic: DB2 for z/OS

Subtopic: 2010

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?

Click Here to Download

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