DB2 Version 9.7 for Linux, UNIX, and Windows

open_loc_curs_blk - Open Local Cursors with Blocking monitor element

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

Element identifier: open_loc_curs_blk
Element type: gauge

Table 1. Snapshot Monitoring Information
Snapshot Level	Logical Data Grouping	Monitor Switch
Application	appl	Basic

Usage

You may use this element in conjunction with open_loc_curs 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).

rej_curs_blk and acc_curs_blk 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_rem_curs_blk.