Connection Monitor 
Use
In the J2EE Engine you can use a preconfigured DataSource object to obtain a connection to the database. The DataSource may use Open, Native, or Vendor SQL.
The Connection Monitor provides information about the connections obtained using Open and Native SQL DataSource objects.
Prerequisites
You must have logged on to the Open SQL Monitors application as a J2EE Engine user from the administrator group.
Activities
To access the Connection Monitor, follow the link ConnectionMonitor on the start page of the Open SQL Monitors application.
The Accessed DataSources screen gives you an overview about all DataSources that are currently accessed on each cluster node of the Java server. For each DataSource the following parameters are displayed:
DataSource Details
Parameter Name |
Description |
Data Source |
The name of the DataSource as defined in the JDBC Connector Service |
DB-Vendor |
The database vendor associated with the DataSource |
Database |
The name of the database associated with the DataSource |
DB-Server |
The hostname of the database server |
DB-User |
The default database user associated with the DataSource |
SQL Type |
The SQL type that is used for accessing the DataSource, either Open or Native SQL |
Connections |
The number of database connections that are currently open on this DataSource |
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. On the Open Connections screen, you see the following information about the connections established using the DataSource:
Connection Details
Parameter Name |
Description |
Connection Id |
A unique identifier of the database connection |
DB User |
The database user for whom the connection was established |
TransactionIsolation |
The transaction isolation level of the connection. For Open SQL only READ_COMMITTED and READ_UNCOMMITTED are supported. |
AutoCommit |
The autocommit mode currently set for the connection |
UsedStmts |
The number of SQL statements that are currently in use by some application – that is, java.sql.Statement objects that have been created through this database connection, but have not yet been closed. |
StmtPoolSize |
The maximum
capacity of the |
PooledStmts |
The number of PreparedStatement objects that are currently in the statement pool regardless of whether or not they are in use |
Requests |
The number of requests issued against the statement pool |
Hits |
The number of requests satisfied by pooled statements |
Efficiency |
The ratio of hits to requests (percentage) |
statement
pool
To view information about the pooled statement for a particular connection, choose its ID. On the Open Statements screen, you can get the following details:
Statement Details
Parameter Name |
Description |
Used? |
Specifies if the statement is currently in use |
Type |
The type of the pooled statement – either Statement (S), PreparedStatement (P), or CallableStatement (C) |
Hits |
The number of successful statement pool requests for the statement; the indicator is not available unless the statement is pooled |
Hash |
The hash value of the statement in the statement pool; the indicator is not available unless the statement is pooled |
SQL Statement |
The SQL statement string |