DB2 Version 9.7 for Linux, UNIX, and Windows

stmt_isolation - Statement isolation monitor element

This element shows the isolation value in effect for the statement while it was being run.

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

The possible isolation level values are:

Usage: You can use this element in conjunction with other statement history entries to understand the cause of the deadlock and the execution behavior of a particular SQL statement.