Unit of Work Stop Timestamp

Snapshot Information Level Application	API Structure(s) sqlm_appl	Monitor Group Unit of Work
Resettable	No
API 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".