This topic defines the JDBC connection pool counters that are used to monitor the performance of JDBC data sources
Performance Monitoring Infrastructure (PMI) collects performance data for 4.0 and 5.0 Java™ Database Connectivity (JDBC) data sources. For a 4.0 data source, the data source name is used. For a 5.0 data source, the Java Naming and Directory Interface (JNDI) name is used.
The JDBC connection pool counters are used to monitor the performance of JDBC data sources. You can find the data by using the Tivoli® performance viewer and looking under each application server by click application_server > JDBC connection pool.
Name | Key | ID | Description | Granularity | Type | Level | Overhead |
CreateCount | connectionPoolModule.numCreates | 1 | The total number of connections created | Per connection pool | CountStatistic | All | Low |
CloseCount | connectionPoolModule.numDestroys | 2 | The total number of connections closed. | Per connection pool | CountStatistic | All | Low |
AllocateCount | connectionPoolModule.numAllocates | 3 | The total number of connections allocated | Per connection pool | CountStatistic | All | Low |
ReturnCount | connectionPoolModule.numReturns | 4 | The total number of connections returned | Per connection pool | CountStatistic | All | Low |
PoolSize | connectionPoolModule.poolSize | 5 | The size of the connection pool | Per connection pool | BoundedRangeStatistic | All | High |
FreePoolSize | connectionPoolModule.freePoolSize | 6 | The number of free connections in the pool (apply to 5.0 DataSource only) | Per connection pool | BoundedRangeStatistic | Basic | High |
WaitingThreadCount | connectionPoolModule.concurrentWaiters | 7 | The number of threads that are currently waiting for a connection | Per connection pool | RangeStatistic | All | High |
FaultCount | connectionPoolModule.faults | 8 | The total number of faults, such as timeouts, in the connection pool | Per connection pool | CountStatistic | All | Low |
PercentUsed | connectionPoolModule.percentUsed | 9 | The average percent of the pool that is in use | Per connection pool | RangeStatistic | Basic | High |
PercentMaxed | connectionPoolModule.percentMaxed | 10 | The average percent of the time that all connections are in use | Per connection pool | RangeStatistic | All | High |
UseTime | connectionPoolModule.avgUseTime | 12 | The average time a connection is used (apply to 5.0 DataSource only). Difference between the time at which the connection is allocated and returned. This value includes the JDBC operation time. | Per connection pool | TimeStatistic | All | Medium |
WaitTime | connectionPoolModule.avgWaitTime | 13 | The average waiting time in milliseconds until a connection is granted | Per connection pool | TimeStatistic | All | Medium |
ManagedConnectionCount | connectionPoolModule.numManagedConnections | 14 | The number of ManagedConnection objects in use for a particular connection pool (applies to V5.0 DataSource objects only) | Per connection factory | CountStatistic | All | Low |
ConnectionHandleCount | connectionPoolModule.numConnectionHandles | 15 | The number of Connection objects in use for a particular connection pool (apply to 5.0 DataSource only) | Per connection factory | CountStatistic | All | Low |
PrepStmtCacheDiscardCount | connectionPoolModule.prepStmtCacheDiscards | 21 | The total number of statements discarded by the least recently used (LRU) algorithm of the statement cache | Per connection pool | CountStatistic | All | Low |
JDBCTime | connectionPoolModule.jdbcOperationTimer | 22 | The amount of time in milliseconds spent running in the JDBC driver which includes time spent in the JDBC driver, network, and database (apply to 5.0 DataSource only) | Per data source | TimeStatistic | All | Medium |