Unit of Work Stop 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_stop_time
timestamp

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

Usage:  You may use this element with "Previous Unit of Work Completion Timestamp" to calculate the total elapsed time between COMMIT/ROLLBACK points, and with "Unit of Work Start Timestamp" 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 "Unit of Work Start Timestamp"). this element will be a valid, non-zero timestamp

• When the application is currently executing a unit of work, this element will contain zeros

• When the application first connects to the database, this element is set to "Connection Request Completion Timestamp".

As a new unit of work is started, the contents of this element are moved to "Previous Unit of Work Completion Timestamp".