DB2 Version 9.7 for Linux, UNIX, and Windows

uow_start_time - Unit of work start timestamp monitor element

The date and time that the unit of work first required database resources.

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 (reported in DETAILS XML document)	Always collected

Table 2. 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 3. Event Monitoring Information
Event Type	Logical Data Grouping	Monitor Switch
Unit of work	-	-
Transaction	event_xact	-

Usage

This resource requirement occurs at the first SQL statement execution of that unit of work:

For the first unit of work, it is the time of the first database request (SQL statement execution) after conn_complete_time.
For subsequent units of work, it is the time of the first database request (SQL statement execution) after the previous COMMIT or ROLLBACK.

Note: The SQL Reference defines the boundaries of a unit of work as the COMMIT or ROLLBACK points.

The database system monitor excludes the time spent between the COMMIT/ROLLBACK and the next SQL statement from its definition of a unit of work. This measurement method reflects the time spent by the database manager in processing database requests, separate from time spent in application logic before the first SQL statement of that unit of work. The unit of work elapsed time does include the time spent running application logic between SQL statements within the unit of work.

You may use this element with the uow_stop_time monitor element to calculate the total elapsed time of the unit of work and with the prev_uow_stop_time monitor element to calculate the time spent in the application between units of work.

You can use the uow_stop_time and the prev_uow_stop_time monitor elements to calculate the elapsed time for the SQL Reference definition of a unit of work.