IBM Books

Previous Transaction


Event Information Level
Transaction

API Structure(s)
sqlm_xaction_event

 

API Element Name
Element Type

prev_stop_time
timestamp

 

Description:  The completion time of the last unit of work.

Usage:  You may use this element with "Event Stop Time" to calculate the total elapsed time between COMMIT/ROLLBACK points, and with "Event Start Time" to calculate the time spent in the application between units of work.

This is the unit of work that completed prior to the unit of work for which this transaction event is generated. The stop time of the unit of work just completed is indicated by "Event Stop Time".

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 ]