Connection Monitor 
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 data sources that are currently accessed on each cluster node of the Java server. For each cluster node, the following parameters are displayed:
Parameter Name |
Description |
|---|---|
Data Source |
The name of the data source and the SQL type it supports. |
Database |
The name, vendor, server (database host), and default user of the database associated with the data source. |
Connections |
The number of database connections that are currently open on this data source. |
Connection Requests |
The number of connection requests for that data source, 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 data source for which you want to monitor the established connections. The displayed list of data sources contains those that have already been used to provide a connection.
To view the available information for a particular connection, choose the relevant data source. 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.