DB2 Help

Open Local Cursors with Blocking

Snapshot Level Application	Logical Data Grouping appl	Monitor Switch Basic
Resettable	No
Element Name Element Type	open_loc_curs_blk gauge

Description: The number of local blocking cursors currently open for this application.

Usage: You may use this element in conjunction with "Open Local Cursors" to calculate the percentage of local cursors that are blocking cursors. If the percentage is low, you may be able to improve performance by improving the row blocking in the application:

Check the pre-compile options for record blocking for treatment of ambiguous cursors
Redefine cursors to allow for blocking (for example, if possible, specify FOR FETCH ONLY on your cursors).

"Rejected Block Cursor Requests" and "Accepted Block Cursor Requests" provide additional information that may help you tune your configuration parameters to improve row blocking in your application.

For blocking cursors used by remote applications, see "Open Remote Cursors with Blocking".