Articles & Content
Topic: 2007 EU
Subtopic: DB2 for z/OS
DATE: 2007-11-5 (11:15 - 12:15)
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!Click to Download
NOTE: These are only open to members of IDUG. If you are not a member, please CLICK HERE for more information.