DB2 Version 9.7 for Linux, UNIX, and Windows

stmt_query_id - Statement query identifier monitor element

This element shows the internal query identifier (ID) given to any SQL statement used as a cursor.

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

Usage

You can use this element, along with the stmt_nest_level monitor element, to uniquely identify an invocation of a particular SQL statement. You can also use this element in conjunction with other statement history entries to understand the cause of the deadlock.