DB2 Version 9.7 for Linux, UNIX, and Windows

stmt_first_use_time - Statement first use timestamp monitor element

This element shows the first time the statement entry was processed. For cursor operations, stmt_first_use_time shows when the cursor was opened. At application coordination nodes, this value reflects the application requests; at non-coordinator nodes, this value reflects when requests were received from the originating node.

Table 1. Event Monitoring Information
Event Type	Logical Data Grouping	Monitor Switch
Locking	-	-
Deadlocks with Details History Values ¹	event_stmt_history	timestamp
Deadlocks with Details History ¹	event_stmt_history	timestamp
Activities	event_activitystmt	timestamp

1: This option has been deprecated. Its use is no longer recommended and might be removed in a future release. Use the CREATE EVENT MONITOR FOR LOCKING statement to monitor lock-related events, such as lock timeouts, lock waits, and deadlocks.

Usage

Use this element in conjunction with other statement history entries to see the sequence of SQL statements that caused the deadlock.