DB2 Version 9.7 for Linux, UNIX, and Windows

completion_status - Completion status monitor element

The status of the unit of work.

Table 1. Event Monitoring Information
Event Type	Logical Data Grouping	Monitor Switch
Unit of work	-	-

Usage

Use this element to determine if the unit of work ended due to a deadlock or abnormal termination. The possible values are listed in the sqllib/misc/DB2EvmonUOW.xsd file:

UNKNOWN
COMMIT
ROLLBACK
GLOBAL_COMMIT
GLOBAL_ROLLBACK
XA_END
XA_PREPARE