Snapshot Level DCS Application |
Logical Data Grouping dcs_appl |
Monitor Switch Basic |
Resettable |
No |
|
Element Name Element Type |
open_cursors gauge | |
Description: The number of cursors currently open for an application.
Usage: Use this element to assess how much memory is being allocated. The amount of memory allocated by the DB2 client, DB2 Connect, or the database agent on the target database is related to the number of cursors that are currently open. Knowing this information can help with capacity planning. For example, each open cursor that is doing blocking has a buffer size of RQRIOBLK. If deferred_prepare is enabled, then two buffers will be allocated.