Articles & Content


Explain Fundamentals (D09)

Topic: 2009 NA

Subtopic: DB2 for LUW

DATE: 2009-5-14 (09:45 AM - 10:45 AM)
SPEAKERS: Paul Turpin (Database Architect)

This presentation will go into the use of the command line explain tools. While there are good reasons for using the Visual Explain tools, there are still opportunities for using the command line explain tools. The presentation will introduce the attendee to interpreting the output of the explain. Some of the red flags to look for in an explain will be covered.

EXP. LEVEL: Beginner,Intermediate


Explanation of the dynexpln, db2expln and db2exfmt tools

Executing the command-line explain, including various options

Basics of reading the explain output

Query performance red flags to look for in explain output

More advanced interpretation of the explain output

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.