Articles & Content

Archives

Analysing Access Plans to Diagnose Performance Problems (F13)

Topic: 2009 NA

Subtopic: DB2 for LUW



DATE: 2009-5-15 (09:15 AM - 10:15 AM)
SPEAKERS: Samir Kapoor (IBM Canada Ltd.)

This presentation is targeted towards advanced DB2 users. It would be most beneficial forAdvanced DBAs who are interested in DB2's cost based optimizer and learn how to analyse access plans, to diagnose query performance issues, directly from DB2 dev and support.We'll go into details of 2 or 3 examples from actual customer scenarios and show how we furtherdebugged the situations and what are the things to look for when debugging an optimizer issue.We'll show how the user can reproduce the problem on a different testing environment. From therewe'll give tips and things to look for to try in the testing environment to improve the access plan.

EXP. LEVEL: Intermediate,Advanced

OBJECTIVES:

Influence optimizer decisions

Identify problems from optimizer access plans and try to improve them.

How to imporve query performance from DB2's cost based optimizer

Understanding cardinality estimates.

Understanding how support and dev go about debugging optimizer issues.



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.