DB2 Version 9.7 for Linux, UNIX, and Windows

stmt_value_isnull - Value has null value monitor element

This element shows whether a data value that is associated with an SQL statement is the NULL value; whether an extended indicator has been used to specify the default value; or that this statement value is unassigned.

Possible values are:

0 or "no" if the value is not NULL
1 or "yes" if the value is NULL
2 or "default" if the extended indicator value of default (-5) was specified for this statement value
3 or "unassigned" if the extended indicator value of unassigned (-7) was specified for this statement value

Table 1. Event Monitoring Information
Event Type	Logical Data Grouping	Monitor Switch
Locking	-	-
Deadlocks with Details History Values¹	stmt_value_isnull	-
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.