DB2 Version 9.7 for Linux, UNIX, and Windows

FP1: New event monitor for dynamic and static SQL statements in package cache

Starting with Version 9.7 Fix Pack 1, the package cache event monitor (CREATE EVENT MONITOR FOR PACKAGE CACHE) records events from both dynamic and static SQL statements when they are flushed from the database package cache.

The new package cache event monitor captures information about cached statement entries after they have been flushed from the database package cache. The event monitor captures an accurate history about statements, that were in the package cache, which can help to resolve SQL query performance and problem determination issues.

The core data collected for a package cache event are the monitor elements reported through the MON_GET_PKG_CACHE_STMT table function. In addition, the event monitor collects information about the executable section of the activity. The collected information is the same for both dynamic and static SQL statements.

After the event monitor data has been captured, the following is a list of the methods you can use to access that data:

An XML document created by the new EVMON_FORMAT_UE_TO_XML table function
Relational tables populated by the new EVMON_FORMAT_UE_TO_TABLES procedure
An XML or text document using the Java™-based db2evmonfmt tool