DB2 Version 9.7 for Linux, UNIX, and Windows

application_handle - Application handle monitor element

A system-wide unique ID for the application. On a single-partitioned database, this identifier consists of a 16-bit counter. On a multi-partitioned database, this identifier consists of the coordinating partition number concatenated with a 16-bit counter. In addition, this identifier is the same on every partition where the application may make a secondary connection.

Table 1. Table Function Monitoring Information
Table Function	Monitor Element Collection Level
MON_GET_CONNECTION table function - Get connection metrics	Always collected
MON_GET_CONNECTION_DETAILS table function - Get detailed connection metrics (reported in DETAILS XML document)	Always collected
MON_GET_UNIT_OF_WORK table function - Get unit of work metrics	Always collected
MON_GET_UNIT_OF_WORK_DETAILS table function - Get detailed unit of work metrics (reported in DETAILS XML document)	Always collected
MON_GET_ACTIVITY_DETAILS table function - Get complete activity details (reported in DETAILS XML document)	Always collected
MON_GET_LOCKS table function - list all locks in the currently connected database	Always collected
MON_GET_MEMORY_POOL - Get memory pool information	Always collected

Table 2. Snapshot Monitoring Information
Snapshot Level	Logical Data Grouping	Monitor Switch
Application	appl_id_info	Basic
Lock	appl_lock_list	Basic
DCS Application	dcs_appl_info	Basic
Transaction	event_xact	-

Table 3. Event Monitoring Information
Event Type	Logical Data Grouping	Monitor Switch
Locking	-	-
Unit of work	-	-
Connections	event_connheader	-
Statements	event_stmt	-
Statements	event_subsection	-
Deadlocks¹	event_dlconn	-
Deadlocks with Details¹	event_detailed_dlconn	-
Threshold violations	event_thresholdviolations	-
Activities	event_activity	-

1: This option has been deprecated. Its use is no longer recommended and might be removed in a future release. Use the CREATE EVENT MONITOR FOR LOCKING statement to monitor lock-related events, such as lock timeouts, lock waits, and deadlocks.

Usage

This monitor element is an alias of the agent_id monitor element.

When returned by MON_GET_MEMORY_POOL, this monitor element is NULL except when the memory pool being described is one of the following:

APPLICATION
STATISTICS
STATEMENT
SORT_PRIVATE.