DB2 Version 9.7 for Linux, UNIX, and Windows

blocking_cursor - Blocking Cursor monitor element

This element indicates if the statement being executed is using a blocking cursor.

Table 1. Snapshot Monitoring Information
Snapshot Level	Logical Data Grouping	Monitor Switch
Application	stmt	Statement
DCS Statement	dcs_stmt	Statement

Table 2. Event Monitoring Information
Event Type	Logical Data Grouping	Monitor Switch
Deadlocks with Details	event_detailed_dlconn	-
Statements	event_stmt	-

Usage: Using blocking for data transfer for a query can improve its performance. The SQL used for a query can affect the use of blocking and might require some modification.