Snapshot Level Database |
Logical Data Grouping dbase |
Monitor Switch Basic |
Resettable |
Yes |
|
Event Type Database |
Logical Data Grouping db_event |
|
Element Name Element Type |
total_cons counter |
Description: Indicates the number of connections to the database (coordinator agents).
Usage: You can use this element in conjunction with the "Database Activation 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. You could also use the ACTIVATE DATABASE command.
| Note: | When you reset this element, its value is set to the number of applications that are currently connected, not to zero. |