IBM Books

Open Local Cursors


Snapshot Information Level
Application

API Structure(s)
sqlm_appl

Monitor Group
Basic

Resettable

No

 

API Element Name
Element Type

open_loc_curs
gauge

 

Description:  The number of local cursors currently open for this application, including those cursors counted by "Open Local Cursors with Blocking".

Usage:  You may use this element in conjunction with "Open Local Cursors with Blocking" 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 Remote Cursors".

[ Top of Page | Table of Contents | Glossary | Index ]

[ DB2 List of Books | Search the DB2 Books ]