DB2 Version 9.7 for Linux, UNIX, and Windows

connections_top - Maximum Number of Concurrent Connections monitor element

The highest number of simultaneous connections to the database since the database was activated.

Element identifier: connections_top
Element type: watermark

Table 1. Snapshot Monitoring Information
Snapshot Level	Logical Data Grouping	Monitor Switch
Database	dbase	Basic

Table 2. Event Monitoring Information
Event Type	Logical Data Grouping	Monitor Switch
Database	event_db	-

Usage

You may use this element to evaluate the setting of the maxappls configuration parameter.

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:

 rem_cons_in + local_cons