DB2 Help

Unit of Work Start Timestamp

Snapshot Level Application DCS Application	Logical Data Grouping appl dcs_appl	Monitor Switch Unit of Work Unit of Work
Resettable	No
Element Name Element Type	uow_start_time timestamp

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

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 "Connection Request Completion Timestamp".
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 "Unit of Work Stop Timestamp" to calculate the total elapsed time of the unit of work and with "Previous Unit of Work Completion Timestamp" to calculate the time spent in the application between units of work.

You can use the "Unit of Work Stop Timestamp" and the "Previous Unit of Work Completion Timestamp" to calculate the elapsed time for the SQL Reference's definition of a unit of work.