Rejected Block Cursor Requests

 
Snapshot Level
Application

 
Logical Data Grouping
appl

 
Monitor Switch
Basic

Resettable

No

Event Type
Connection

Logical Data Grouping
conn_event

Element Name
Element Type

rej_curs_blk
counter

Description:  The number of times that a request for an I/O block at server was rejected and the request was converted to non-blocked I/O.

Usage:  If there are many cursors blocking data, the communication heap may become full. When this heap is full, an error is not returned. Instead, no more I/O blocks are allocated for blocking cursors. If cursors are unable to block data, performance can be affected.

If a large number of cursors were unable to perform data blocking, you may be able to improve performance by:

• Increasing the size of the query_heap database manager configuration parameter. For more information see the Administration Guide.