Articles & Content

Archives

Demystifying the Dynamic Statement Cache (A10)

Topic: DB2 for z/OS

Subtopic: 2007



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

OBJECTIVES:

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



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.