DB2 Version 9.7 for Linux, UNIX, and Windows

uow_comp_status - Unit of Work Completion Status monitor element

The status of the unit of work and how it stopped.

Element identifier
uow_comp_status
Element type
information
Table 1. Snapshot Monitoring Information
Snapshot Level Logical Data Grouping Monitor Switch
Application appl Unit of Work
DCS Application dcs_appl Basic
Table 2. Event Monitoring Information
Event Type Logical Data Grouping Monitor Switch
Transactions event_xact -
Usage
You may use this element to determine if the unit of work ended due to a deadlock or abnormal termination. It may have been:
  • Committed due to a commit statement
  • Rolled back due to a rollback statement
  • Rolled back due to a deadlock
  • Rolled back due to an abnormal termination
  • Committed at normal application termination.
  • Unknown as a result of a FLUSH EVENT MONITOR command for which units of work were in progress.
Note: API users should refer to the header file (sqlmon.h) containing definitions of database system monitor constants.
Parent topic: Database system monitor elements