DB2 Version 9.7 for Linux, UNIX, and Windows

executable_id - Executable ID monitor element

An opaque binary token generated on the data server that uniquely identifies the SQL statement section that was executed. For non-SQL activities, a 0-length string value is returned.

Table 1. Table Function Monitoring Information
Table Function	Monitor Element Collection Level
MON_GET_ACTIVITY_DETAILS table function - Get complete activity details (reported in DETAILS XML document)	Always collected
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
Activity	event_activitystmt	-
Package cache	-	COLLECT BASE DATA

Usage

Use this monitor element as input to different monitoring interfaces to obtain data about the section. The MON_GET_PKG_CACHE_STMT table function, which is used to get SQL statement activity metrics in the package cache, takes the executable ID as input.