Previous Unit of Work Completion Timestamp

Snapshot Information Level
Application

API Structure(s)
sqlm_appl

Monitor Group
Unit of Work

Resettable

No

API Element Name
Element Type

prev_uow_stop_time
timestamp

Description:  This is the time the unit of work completed.

Usage:  You may use this element with "Unit of Work Stop Timestamp" to calculate the total elapsed time between COMMIT/ROLLBACK points, and with "Unit of Work Start Timestamp" to calculate the time spent in the application between units of work. The time of one of the following:

• For applications currently within a unit of work, this is the time that the latest unit of work completed.

• For applications not currently within a unit of work (the application has completed a unit of work, but not yet started a new one), this is the stop time of the last unit of work that completed prior to the one that just completed. The stop time of the one just completed is indicated Unit of Work Stop Timestamp.

• For applications within their first unit of work, this is the database connection request completion time.

[ Top of Page | Table of Contents | Glossary | Index ]

[ DB2 List of Books | Search the DB2 Books ]