Articles & Content

Archives

[C08] Analyzing Access Plans to Diagnose Performance Problems

Topic: DB2 for LUW

Subtopic: 2013



This presentation is targeted towards advanced DB2 users. It would be most beneficial for Advanced DBAs who are interested in DB2's cost based optimizer and learn how to analyze access plans, to diagnose query performance issues, directly from DB2 devevelopment and support. We'll go into details of 8 different examples from actual customer scenarios and show how we further debugged the situation and what are the things to look for when debugging an optimizer issue.  It is mainly focused on cardinality estimates.  We’ll show how one can improve the cardinality estimates via different mechanisms available in DB2, eg. runstats, cgs, reopt & statviews.   As well, we’ll show an example of a problem where optimizer guidelines may come in handy, a problem where analyzing the optimized statement helped figure out what the problem was and a problem involving stmtheap.



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.