JDBC connection pool counters

Performance Monitoring Infrastructure (PMI) collects performance data for 4.0 and 5.0 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. We can find the data by using the Tivoli performance viewer and looking under each application server by click application_server > JDBC connection pool.

Counter definitions

Name Key Description Version Granularity Type Level
CreateCount connectionPoolModule.numCreates The total number of connections created 3.5.5 and later Per connection pool CountStatistic Low
PoolSize connectionPoolModule.poolSize The size of the connection pool 3.5.5 and later Per connection pool BoundedRangeStatistic High
FreePoolSize connectionPoolModule.freePoolSize The number of free connections in the pool 5.0 Per connection pool BoundedRangeStatistic High
AllocateCount connectionPoolModule.numAllocates The total number of connections allocated 3.5.5 and later Per connection pool CountStatistic Low
ReturnCount connectionPoolModule.numReturns The total number of connections returned 4.0 and later Per connection pool CountStatistic Low
WaitingThreadCount connectionPoolModule.concurrentWaiters The number of threads that are currently waiting for a connection 3.5.5 and later Per connection pool RangeStatistic High
FaultCount connectionPoolModule.faults The total number of faults, such as timeouts, in the connection pool 3.5.5 and later Per connection pool CountStatistic Low
CloseCount connectionPoolModule.numDestroys The total number of connections closed. 3.5.5 and later Per connection pool CountStatistic Low
WaitTime connectionPoolModule.avgWaitTime The average waiting time in milliseconds until a connection is granted 5.0 Per connection pool TimeStatistic Medium
UseTime connectionPoolModule.avgUseTime The average time a connection is used (Difference between the time at which the connection is allocated and returned. This value includes the JDBC operation time.) 5.0 Per connection pool TimeStatistic Medium
PercentUsed connectionPoolModule.percentUsed The average percent of the pool that is in use 3.5.5 and later Per connection pool RangeStatistic High
PercentMaxed connectionPoolModule.percentMaxed The average percent of the time that all connections are in use 3.5.5 and later Per connection pool RangeStatistic High
PrepStmtCacheDiscardCount connectionPoolModule.prepStmtCacheDiscards The total number of statements discarded by the least recently used (LRU) algorithm of the statement cache 4.0 and later Per connection pool CountStatistic Low
ManagedConnectionCount connectionPoolModule.numManagedConnections The number of ManagedConnection objects in use for a particular connection pool (applies to V5.0 DataSource objects only) 5.0 Per connection factory CountStatistic Low
ConnectionHandleCount connectionPoolModule.numConnectionHandles The number of Connection objects in use for a particular connection pool (apply to 5.0 DataSource only) 5.0 Per connection factory CountStatistic Low
JDBCTime connectionPoolModule.jdbcOperationTimer The amount of time in milliseconds spent running in the JDBC driver (includes time spent in the JDBC driver, network, and database) 5.0 Per data source TimeStatistic Medium


 



 

 

Tivoli is a trademark of the IBM Corporation in the United States, other countries, or both.