DB2 Version 9.7 for Linux, UNIX, and Windows

uow_stop_time - Unit of work stop timestamp monitor element

The date and time that the most recent unit of work completed, which occurs when database changes are committed or rolled back.

Table 1. Snapshot Monitoring Information
Snapshot Level	Logical Data Grouping	Monitor Switch
Application	appl	Unit of Work, Timestamp
DCS Application	dcs_appl	Unit of Work, Timestamp

Table 2. Event Monitoring Information
Event Type	Logical Data Grouping	Monitor Switch
Unit of work	-	-

Usage

Use this element with the prev_uow_stop_time monitor element to calculate the total elapsed time between COMMIT/ROLLBACK points, and with the uow_start_time monitor element to calculate the elapsed time of the latest unit of work.

The timestamp contents will be set as follows:

When the application has completed a unit of work and has not yet started a new one (as defined in the uow_start_time monitor element), this element reports a valid, non-zero timestamp.
When the application is currently executing a unit of work, this element reports zeros.
When the application first connects to the database, this element is set to the value of the conn_complete_time monitor element

As a new unit of work is started, the contents of this element are moved to the prev_uow_stop_time monitor element.