Db2 (LUW) Package Cache - New RFE to not Flush statements that cannot be reused

Joe Geller

Db2 (LUW) Package Cache - New RFE to not Flush statements that cannot be reused

I've created a new RFE that could use your votes (and earn my gratitude). The url is  https://www.ibm.com/developerworks/rfe/execute?use_case=viewRfe&CR_ID=114027  The package cache is a great tool for performance monitoring of statements and its use is encouraged by IBM.  However, performance monitoring is a step-child. The main function of the package cache is for dynamic statement reuse (i.e. no prepare).  If a statement cannot be reused it is automatically flushed from the package cache.  This eliminates your ability to easily check the performance of these statements.

A statement cannot be reused for a number of reasons such as:

- it uses a global temp table (but of course we want to be able to analyze the performance of these)

- runstats has been run on one of the objects (that's fine, don't reuse it, but let us see how the query performed before the runstats).

Please vote for this.  Thank you.

Joe