DB2 Version 9.7 for Linux, UNIX, and Windows

num_coord_exec - Number of executions by coordinator agent monitor element

The number of times this section was executed by a coordinator agent.

Table 1. Table Function Monitoring Information
Table Function Monitor Element Collection Command and 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