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