JDBC Connection Pool Statistics Test

The Java Database Connectivity (JDBC) is an industry standard for database-independent connectivity between the Java platform and a wide range of databases. The JDBC interface provides a call-level API for SQL-based and XQuery-based database access.

This test auto discovers the JDBC Provider configurable service of the IBM Integration Bus and reports how well connections are utilized by each service in the connection pool. Using this test, you can figure out the number of connections that are available for use and the requests that are handled by the connection pool. This test proactively alerts administrators to slowdowns/bottlenecks in obtaining connections and the timeouts experienced while waiting for connections.

Target of the test : An IBM Integration Bus

Agent deploying the test : An internal/remote agent.

Outputs of the test : One set of results for each Execution group:JDBC Provider configurable service that is using connection pooling in the IBM Integration Bus that is to be monitored

Configurable parameters for the test
Parameters	Description
Test period	How often should the test be executed.
Host	The host for which the test is to be configured.
Port	The port on which the specified host listens.
JNDI Namespace Location	Indicate where the JNDI namespace has been created. For this, select one of the following options: File or LDAP. Select File if the JNDI namespace is created in the same location as that of the IIB server.
SSL	If you have chosen LDAP as the JNDI Namespace Location wherein the LDAP server communicating with the IIB server that is to be monitored is an SSL-enabled server, then set the SSL flag to Yes. By default, this flag is set to No.
User DN and Password	Here, provide the credentials of the Active Directory user created as explained in Creating a user in the Active Directory server, if the target IIB server is monitored in an agentless manner. If the IIB server is to be monitored in an agent based manner, specify none against these parameters.
Confirm Password	Confirm the Password by retyping it in this text box.
JNDI Provider URL	Specify the URL that was specified as the provider URL while creating the initial context. To know the Provider URL, refer to Agent based monitoring of the IIB server if you choose to monitor the target IIB server in an agent based manner and Agentless Monitoring of the IIB server if you chose to monitor the target IIB server in an agentless manner.
TopicConnectionFactory	Specify the name of the connection factory in this text box. If you have chosen to monitor the target IIB server in an agent-based manner, refer to Creating a Connection Factory and if you have chosen to monitor the target IIB server in an agentless manner, refer to Creating a Connection Factory.
JMS Resource Stats	Specify the name of the JMS destination that you have created for storing the Resource statistics. If you chose to monitor the target IIB server in an agentless manner, refer to Creating the JMS Destinations and if you choose to monitor the target IIB server in an agent based manner, refer to Agent based monitoring of the IIB server.
JMS Flow Stats	Specify the name of the JMS destination that you have created for storing the Message flow statistics. If you chose to monitor the target IIB server in an agentless manner, refer to Creating the JMS Destinations and if you choose to monitor the target IIB server in an agent based manner, refer to Agent based monitoring of the IIB server.

Measurements made by the test
Measurement	Description	Measurement Unit	Interpretation
Current connection in the pool	Indicates the number of connections that are currently available in the connection pool utilized by this service.	Number
Connection pool usage	Indicates the percentage of connections that were utilized in the connection pool during the last measurement period.
Free connections in the pool	Indicates the number of connections that were available for use in the connection pool during the last measurement period.
Requests handled by the pool	Indicates the rate at which requests were handled by the connection pool during the last measurement period.	Percent	A value close to 100 indicates an overload condition.
Connection wait requests	Indicates the rate at which requests for a connection could not be satisfied immediately.	Number	A high value is desired for this measure. A gradual/sudden increase in the value of this measure indicates that the connection pool is currently overloaded.
Connection timed out requests	Indicates the rate at which the requests for connections could not be satisfied by this connection pool within 15 seconds during the last measurement period.	Requests/sec
Maximum delay	Indicates the maximum time taken to allocate a connection in the connection pool during the last measurement period.	Millisecs	A high value for this measure is a cause of concern.