ListDbConnections
Description:
Returns a list of all open and idle JDBC connections that have been opened by a single instance of ActiveMatrix BusinessWorks engine.
Method Arguments:
None
Output:
The following table describes the output of this microagent method:
Column Name |
Description |
Connection-State |
State of the JDBC Connection. The connection state can be Active or Idle. |
Connection-Name |
Name of the JDBC Connection. |
User-Name |
Username used by the JDBC Connection resource to to connect the database. |
Connection-Owner |
Owner of the JDBC Connection. For active connections, this field displays the activity name and the job-id for which the connection has been acquired. For idle connections, this field is empty. |
Idle-Time |
Time in milliseconds for which the JDBC Connection has been idle. For active connections, the value is 0. |
Note |
The statistics for idle connections are available for the time set by the engine property |