DB2 Version 9.7 for Linux, UNIX, and Windows

start_time - Event Start Time monitor element

The date and time of unit of work start, statement start, or deadlock detection. This element, in the event_start API structure indicates the start of the event monitor.

Table 1. Event Monitoring Information
Event Type	Logical Data Grouping	Monitor Switch
Database	event_start	Timestamp
Statements	event_stmt	Timestamp
Deadlocks	event_deadlock	Timestamp
Deadlocks	event_dlconn	Timestamp
Deadlocks with Details	event_detailed_dlconn	Timestamp

Usage: You can use this element to correlate the deadlock connection records to the deadlock event record, and in conjunction with stop_time to calculate the elapsed statement or transaction execution time.
Note: When the Timestamp switch is OFF, this element reports "0".