IBM Books

Maximum Number of Concurrent Connections


Snapshot Information Level
Database

API Structure(s)
sqlm_dbase

Monitor Group
Basic

Resettable

No

 

Event Information Level
Database

API Structure(s)
sqlm_db_event

 

API Element Name
Element Type

connections_top
highest

 

Description:  The highest number of simultaneous connections to the database since the first application connected to the database.

Usage:  You may use this element to evaluate the setting of the maxappls configuration parameter, which is described in the Administration Guide.

If the value of this element is the same as the maxappls parameter, it is likely that some database connection requests were rejected, since maxappls limits the number of database connections allowed.

The current number of connections at the time the snapshot was taken can be calculated using the following formula:

 remote connections to database manager + local connections

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

[ DB2 List of Books | Search the DB2 Books ]