IBM Books

Local Connections


Snapshot Information Level
Database Manager

API Structure(s)
sqlm_db2

Monitor Group
Basic

Resettable

No 

 

API Element Name
Element Type

local_cons
gauge

 

Description:  The number of local applications that are currently connected to a local database within the database manager instance being monitored.

Usage:  This number can help you determine the level of concurrent processing occurring in the database manager. This value will change frequently, so you may need to sample it at specific intervals over an extended period of time to get a realistic view of system usage.

This number only includes applications that were initiated from the same node as the database manager. The applications are connected, but may or may not be executing a unit of work in the database.

When used in conjunction with the "Remote Connections To Database Manager" monitor element, this element can help you adjust the setting of the maxagents configuration parameter, described in the Administration Guide.

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

[ DB2 List of Books | Search the DB2 Books ]