VET Provide function to report number of open connections per userid

Request to amend the database connection manager to provide details of the connections and the number of open connections.
The best way would be to provide the userid / spid / epoch of when the connection was opened in a data structure. Any other information would be useful e.g. sessionid or ip address

The system administrator could then write a script to read that and take the necessary actions. Having the detail would allow the system administrators to write scripts to take advantage of the information.

Use case
==

The database manager code currently records details of the open connections and which users opened those connections.

I have investigated a number of connection leaks.
The watchdog WARN entries are very helpful in identifying the code but it doesn't help understand the circumstances that triggered the code or the users who were using the connection.

IBM Support ask for details of the steps that replicate the problems but the current information doesn't help with that.

Switching the watchdog logger to DEBUG provides critical information (e.g. count of number of connections per user & when connections open/close)
Unfortunately there are a lot of open/close operations and the logs can become deluged with log entries that are not useful particularly when dealing with a production problem.


This enhancement will allow support tools/people to query the details in real time to help them identify the users who were performing the actions when the connections were opened.


Triggering log collection
--
the trigger could ask an MDM system (for mobile devices) to send the logs, gather the relevant server logs (e.g. JVM/IHS) for the time period.