DB2 Version 9.7 for Linux, UNIX, and Windows

stmt_source_id - Statement source identifier monitor element

This element shows the internal identifier (ID) given to the source of the SQL statement that was run.

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	-

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

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