Articles & Content


Demystifying the Dynamic Statement Cache (A10)

Topic: 2007 NA

Subtopic: DB2 for z/OS

DATE: 2007-5-9 (01:40 PM - 02:40 PM)
SPEAKERS: William Arledge (BMC Software)

The Dynamic Statement Cache in DB2 has the potential to greatly improve performance for dynamic SQL. As with most things, there are tradeoffs and costs to be considered with this DB2 feature. Meanwhile, the implementation of the cache often changes from release to release. This technical session will discuss the Dynamic Statement Cache to help you understand how the cache is implemented, the contents of the cache and how you can mine the statistics stored there, potential benefits and costs of the cache, including potential issues related to use of the Dynamic Statement Cache.

EXP. LEVEL: Intermediate


Bring together information from multiple to build a better picture of the Dynamic Statement Cache

Describe the differences in the cache between DB2 V7 and V8

Discuss enabling and using the cache, including when using the cache may not be indicated

Describe the statistics that are associated with SQL statements in the cache and discuss the overhead related to this statistics collection

Discuss evaluation of cached information including using the Explain to evaluate the statements

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.