Connection Monitor 

Use

The Connection Monitor provides information about the connections obtained using Open and Native SQL DataSource objects.

Prerequisites

You are in Problem Management → Database → Open SQL Monitors → Connection Monitor.

Activities

The Accessed DataSources screen gives you an overview of all DataSources that are currently accessed on each cluster node of the Java server. For each cluster node, the following parameters are displayed:

DataSource Details

Parameter Name	Description
DataSource	The name of the DataSource and the SQL type it supports.
Database	The name, vendor, server (database host), and default user  of the database associated with the DataSource.
Connections	The number of database connections that are currently open on this DataSource.
Connection Requests	The number of connection requests for that DataSource, according to their state, that is, Successful, Waiting, Timeout, Error.
Connection Properties	The properties for each connection, such as wait time, cleanup interval, timeout, and so on.

 

You can choose a DataSource for which you want to monitor the established connections. The displayed list of DataSources contains those that have already been used to provide a connection.

To view the available information for a particular connection, choose the relevant DataSource. The Open Connections screen area displays the details for each connection.

To view information about statements for a particular connection, choose the connection. The Open Statements screen area displays details of the SQL statement string, the type of the statement, and so on.