Articles & Content
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.