Articles & Content


Snapping the DB2 for z/OS Dynamic Statement Cache (F01)

Topic: DB2 for z/OS

Subtopic: 2009

DATE: 2009-10-5 (11:30 - 12:30)
SPEAKERS: Daniel Luksetich (YL&A)

DB2 for z/Os does a pretty good job of caching dynamic SQL statements in order to avoid recompiling the statements on the fly. this can save significant system resources. However, we still ahve the problem of figuring out just what statements are coming in to DB2, and how they are performing. DB2 for z/OS version 8 introduced the ability to capture and report on the statements in the dynamic statement cache. This presentation will focus on the use of this facility, how to manage it, and how to report, understand, and act on the available performance information. Data from real-world case studies will be presented

EXP. LEVEL: Beginner,Intermediate,Advanced


introduction to the dynamic statement cache

how to extract the statements from the statement cache

interpreting the performance metrics from the Explain of the statement cache

how to manage the output from the Explain of the statement cache

understanding dynamic statement performance and the alternatives

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.