there is audit coming (I think) ...
So, what I found so far is you can get from the database-name.lic file the number of active "interactive" connections. Going to write a quick code to see what the average interactive count is are for a given day and then figure out if our default min and max are setup correctly. I'm not a DBA so do not off hand if there's an easier way to get this information. I did look at asbman query option but it did not have this info.
Progress KB - What is the database license file?
Example: databasename.lic
06/24/04 19:00:00 64 1 2 1 0 1 0 1 1 1
06/24/04 20:00:00 64 1 1 1 0 0 0 1 1 1
06/24/04 21:00:00 64 3 3 0 2 2 0 1 1 0
06/24/04 22:00:00 64 8 9 3 7 8 2 1 1 1
Here's what the columns denote:
1. Current date
2. Current time
3. Number of licensed users specified by the configuration file (if -1 shows, it means that an unlimited number of users are licensed)
4. Current number of total connections
5. Maximum number of total connections
6. Minimum number of total connections
7. Current number of interactive connections
8. Maximum number of interactive connections for the last hour
9. Minimum number of interactive connections for the past hour
10. Current number of batch connections
11. Maximum number of batch connections for the past hour
12. Minimum number of batch connections for the past hour