Snapshot Level Application DCS Application |
Logical Data Grouping appl dcs_appl |
Monitor Switch Unit of Work Unit of Work |
Resettable |
No |
|
Element Name Element Type |
uow_start_time timestamp |
Description: The date and time that the unit of work first required database resources.
Usage: This resource requirement occurs at the first SQL statement execution of that unit of work:
| Note: | The SQL Reference defines the boundaries of a unit of work as the COMMIT or ROLLBACK points. |
The database system monitor excludes the time spent between the COMMIT/ROLLBACK and the next SQL statement from its definition of a unit of work. This measurement method reflects the time spent by the database manager in processing database requests, separate from time spent in application logic before the first SQL statement of that unit of work. The unit of work elapsed time does include the time spent running application logic between SQL statements within the unit of work.
You may use this element with "Unit of Work Stop Timestamp" to calculate the total elapsed time of the unit of work and with "Previous Unit of Work Completion Timestamp" to calculate the time spent in the application between units of work.
You can use the "Unit of Work Stop Timestamp" and the "Previous Unit of Work Completion Timestamp" to calculate the elapsed time for the SQL Reference's definition of a unit of work.