DB2 Version 9.7 for Linux, UNIX, and Windows

workload_id - Workload ID monitor element

An integer that uniquely identifies a workload.

Table 1. Table Function Monitoring Information
Table Function	Monitor Element Collection Level
MON_GET_WORKLOAD table function - Get workload metrics	Always collected
MON_GET_WORKLOAD_DETAILS table function - Get detailed workload metrics	Always collected

Table 2. Snapshot Monitoring Information
Snapshot Level	Logical Data Grouping	Monitor Switch
Application	appl_info	Basic

Table 3. Event Monitoring Information
Event Type	Logical Data Grouping	Monitor Switch
Locking	-	-
Unit of work	-	-
Activities	event_activity (reported in the details_xml document)	ACTIVITY METRICS BASE
Statistics	event_scstats (reported in the metrics document)	REQUEST METRICS BASE
Statistics	event_wlstats (reported in the metrics document)	REQUEST METRICS BASE
Unit of work	Reported in the in the system_metrics document.	-
Statistics	event_wlstats	-
Statistics	event_histogrambin	-
Activities	event_activity	-
Threshold violations	event_thresholdviolations	-

Usage

Use this ID to uniquely identify the workload to which this activity, application, histogram bin, or workload statistics record belongs.

The value of this element is 0 when the following conditions are met: