DB2 Version 9.7 for Linux, UNIX, and Windows

last_metrics_update - Metrics last update timestamp monitor element

Timestamp reflecting the last time metrics were updated for this cache entry.

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	ACTIVITY METRICS BASE
MON_GET_PKG_CACHE_STMT_DETAILS table function - get detailed metrics for package cache entries	ACTIVITY METRICS BASE

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