Snapshot Information Level Database |
API Structure(s) sqlm_dbase |
Monitor Group Basic |
Resettable |
Yes |
|
Event Information Level Database |
API Structure(s) sqlm_db_event |
|
API Element Name Element Type |
total_cons counter |
Description: Indicates the number of connections to the database.
Usage: You can use this element in conjunction with the "First Database Connect Timestamp" and the "Start Database Manager Timestamp" monitor elements to calculate the frequency at which applications have connected to the database.
If the frequency of connects is low, you may want to do a dummy connect initially before connecting any other application, because of the extra overhead that sometimes accompanies the first connect to a database (for example, initial buffer pool allocation or autorestart). This will result in subsequent connects being processed at a higher rate.
| Note: | When you reset this element, its value is set to the number of applications that are currently connected, not to zero. |
[ Top of Page | Table of Contents | Glossary | Index ]