Articles & Content


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

Topic: 2009 EU

Subtopic: DB2 for z/OS

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

This file is being provided by IDUG. We would encourage you to join IDUG to get full access to all of our files and resources. Joining IDUG is FREE and signing up is simple. Click here to join! or login!

Download File
Click to Download

NOTE: These are only open to members of IDUG. If you are not a member, please CLICK HERE for more information.