DB2 Version 9.7 for Linux, UNIX, and Windows

activity_id - Activity ID monitor element

Counter which uniquely identifies an activity for an application within a given unit of work.

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
Table 2. Event Monitoring Information
Event Type Logical Data Grouping Monitor Switch
Locking - -
Activities event_activity -
Activities event_activitystmt -
Activities event_activityvals -
Threshold violations event_thresholdviolations -

Usage

Use this element in conjunction with other activity history elements for analysis of the behavior of an activity.

To uniquely identify an activity outside its unit of work, use the combination of activity_id and uow_id plus one of the following: appl_id or agent_id.