DB2 Version 9.7 for Linux, UNIX, and Windows

open_rem_curs - Open Remote Cursors monitor element

The number of remote cursors currently open for this application, including those cursors counted by open_rem_curs_blk.

Element identifier
open_rem_curs
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_rem_curs_blk to calculate the percentage of remote 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. See open_rem_curs_blk for more information.

For the number of open cursors used by applications connected to a local database, see open_loc_curs.

Parent topic: Database system monitor elements
Related reference:
open_loc_curs - Open Local Cursors monitor element
open_rem_curs_blk - Open Remote Cursors with Blocking monitor element