Snapshot Information Level Database |
API Structure(s) sqlm_dbase |
Monitor Group Basic |
Resettable |
No |
|
API Element Name Element Type |
appls_in_db2 gauge |
Description: Indicates the number of applications that are currently connected to the database, and for which the database manager is currently processing a request.
Usage: You can use this element to understand how many of the database manager agent tokens are being used by applications connected to this database. If the sum of "Remote Connections Executing in the Database Manager" and "Local Connections Executing in the Database Manager" is equal to the value of the maxcagents configuration parameter, you may want to increase the value of that parameter, as described in the Administration Guide.
You can also use this element with "Current Applications Waiting On Locks" to calculate the lock concurrency of your applications. The following formula indicates the percentage of connections that are not waiting on a lock;
100 * ( 1- ( current applications waiting on locks
/ applications executing in the database manager currently ) )
[ Top of Page | Table of Contents | Glossary | Index ]