Resource statistics data: JDBC Connection Pools
Learn about the data that is returned for the JDBC Connection Pools resource type when you activate resource statistics collection.
You can view these statistics in the web user interface, or you can write a program that subscribes to a publication (single XML message) that returns this data. For an example of the publication message, see Example XML output.
A
statistics summary is returned for each JDBC provider defined in the
integration node configurable service that is switched to use connection
pools. The following examples are named JDBC data sources:
- IBM Db2
- Oracle
- Microsoft SQLServer
The following table describes the measurements that are
returned for each JDBC Provider configurable service.
| Measurements | Description |
|---|---|
| NameOfJDBCProvider | The name of the JDBCProviders configurable service
that is using connection pooling. If there are no connection pools
started, this defaults to none. |
| MaxSizeOfPool | The maximum size of the connection pool. |
| ActualSizeOfPool | A snapshot of the number of connections currently in the pool when the statistics were reported. |
| CumulativeRequests | A count of the number of requests received by the connection pool during this accounting period. |
| CumulativeDelayedRequests | The number of times a request for a connection could not be satisfied immediately, because the number of allocated connections reached the maximum pool size and no connections are currently available. |
| MaxDelayInMilliseconds | The maximum time a caller waited for a connection to be allocated, in milliseconds. |
| CumulativeTimedOutRequests | A count of the number of requests for connections that could not be satisfied within 15 seconds. |