IBM Books

Event Start Time


Event Information Level
Database
Transaction
Statement
Deadlock

API Structure(s)
sqlm_evmon_start_event
sqlm_xaction_event
sqlm_stmt_event
sqlm_deadlock_event
sqlm_dlconn_event

 

API Element Name
Element Type

start_time
timestamp

 

Description:  The date and time of unit of work start, statement start, or deadlock detection.

This element, in the sqlm_evmon_start_event API structure indicates the start of the event monitor.

Usage:  You can use this element to correlate the deadlock connection records to the deadlock event record, and in conjunction with "Event Stop Time" to calculate the elapsed statement or transaction execution time.

For a statement event where the "Statement Operation" monitor element is FETCH, this is the time of the first fetch.

[ Top of Page | Table of Contents | Glossary | Index ]

[ DB2 List of Books | Search the DB2 Books ]