DB2 Version 9.7 for Linux, UNIX, and Windows

uow_id - Unit of work ID monitor element

The unit of work identifier. The unit of work ID is unique within an application handle.

Table 1. Table Function Monitoring Information
Table Function Monitor Element Collection Level
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 Always collected
MON_GET_ACTIVITY_DETAILS table function - Get complete activity details Always collected
Table 2. Event Monitoring Information
Event Type Logical Data Grouping Monitor Switch
Locking - -
Unit of work - -
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.

You can also use this element with the activity_id and appl_id monitor elements to uniquely identify an activity.

Parent topic: Database system monitor elements