DB2 Version 9.7 for Linux, UNIX, and Windows

stmt_history_id - Statement history identifier monitor element

This numerical element shows the position in which the statement was run within the unit of work indicated by the sequence_no element, relative to other statement history elements. The earliest statement run in the unit of work will have the lowest value. If the same statement is run twice in the same unit of work, two different occurrences of the statement will be shown with two different stmt_history_id values.

Table 1. Event Monitoring Information
Event Type Logical Data Grouping Monitor Switch
Deadlocks with Details History Values event_stmt_history -
Deadlocks with Details History Values event_data_value -
Deadlocks with Details History event_stmt_history -
Usage
You can use this information to see the sequence of SQL statements that caused the deadlock.
Parent topic: Database system monitor elements