DB2 Version 9.7 for Linux, UNIX, and Windows

open_loc_curs - Open Local Cursors monitor element

The number of local cursors currently open for this application, including those cursors counted by open_loc_curs_blk.

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_blk 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.
For cursors used by remote applications, see open_rem_curs.