This is the time the unit of work completed.
- Element identifier
- prev_uow_stop_time
- Element type
- timestamp
Table 1. Snapshot Monitoring Information| Snapshot Level |
Logical Data Grouping |
Monitor Switch |
|---|
| Application |
appl |
Unit of Work, Timestamp |
| DCS Application |
dcs_appl |
Unit of Work, Timestamp |
Table 2. Event
Monitoring Information| Event Type |
Logical Data Grouping |
Monitor Switch |
|---|
| Transaction |
event_xact |
- |
- Usage
- You may use this element with uow_stop_time to calculate
the total elapsed time between COMMIT/ROLLBACK points, and with uow_start_time 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 uow_stop_time.
- For applications within their first unit of work,
this is the database connection request completion time.
DB2 Version 9.7 for Linux, UNIX, and Windows