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 Engine.DBConnection.idleTimeout. By default, this property is set to 5 minutes.