DB2 Version 9.7 for Linux, UNIX, and Windows

num_exec_with_metrics - Number of executions with metrics collected monitor element

The number of times that this SQL statement section has been executed with the metrics collected. This element can be used to calculate the per execution value for monitor elements for statements in the package cache.

Table 1. Table Function Monitoring Information
Table Function	Monitor Element Collection Level
MON_GET_PKG_CACHE_STMT table function - Get SQL statement activity metrics in the package cache	Always collected
MON_GET_PKG_CACHE_STMT_DETAILS table function - get detailed metrics for package cache entries	Always collected

Table 2. Event Monitoring Information
Event Type	Logical Data Grouping	Monitor Switch
Package cache	-	COLLECT BASE DATA