DB2 Version 9.7 for Linux, UNIX, and Windows

stmt_value_index - Value index monitor element

This element represents the position of the input parameter marker or host variable used in the SQL statement.

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

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 in conjunction with other statement history entries to understand the cause of the deadlock.