JDBC connection pool counters: WAS v5.1

JDBC connection pool counters

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 JNDI name is used.
The JDBC connection pool counters are used to monitor the JDBC data sources performance. You can find the data by using the Tivoli Performance Viewer and looking under each appserver. Click application_server > JDBC connection pool.

Name Key Description Granularity Type Level
Num creates connectionPoolModule.numCreates Total number of connections created Per connection pool CountStatistic Low
Pool size connectionPoolModule.poolSize The size of the connection pool Per connection pool BoundedRangeStatistic High
Free pool size connectionPoolModule.freePoolSize The number of free connections in the pool Per connection pool BoundedRangeStatistic High
Num allocates connectionPoolModule.numAllocates Total number of connections allocated Per connection pool CountStatistic Low
Num returns connectionPoolModule.numReturns Total number of connections returned Per connection pool CountStatistic Low
Concurrent waiters connectionPoolModule.concurrentWaiters Number of threads that are currently waiting for a connection Per connection pool RangeStatistic High
Faults connectionPoolModule.faults Total number of faults, such as timeouts, in the connection pool Per connection pool CountStatistic Low
Num closes connectionPoolModule.numDestroys Number of times bean objects were freed Per connection pool CountStatistic Low
Avg wait time (ms) connectionPoolModule.avgWaitTime Average waiting time in milliseconds until a connection is granted Per connection pool TimeStatistic Medium
Avg use time (ms) connectionPoolModule.avgUseTime Average time a connection is used (Difference between the time at which the connection is allocated and returned. This includes the JDBC operation time.) Per connection pool TimeStatistic Medium
Percent used connectionPoolModule.percentUsed Average percent of the pool that is in use Per connection pool RangeStatistic High
Percent maxed connectionPoolModule.percentMaxed Average percent of the time that all connections are in use Per connection pool RangeStatistic High
Prepared stmt cache discards connectionPoolModule.prepStmtCacheDiscards Total number of statements discarded by the LRU algorithm of the statement cache Per connection pool CountStatistic Low
Num managed connections connectionPoolModule.numManagedConnections Number of ManagedConnection objects in use for a particular connection pool (apply to 5.0 DataSource only) Per connection factory CountStatistic Low
Num connection handles connectionPoolModule.numConnectionHandles Number of Connection objects in use for a particular connection pool (apply to 5.0 DataSource only) Per connection factory CountStatistic Low
JDBC time connectionPoolModule.jdbcOperationTimer Amount of time in milliseconds spent executing in the JDBC driver (includes time spent in JDBC driver, network and database) Per data source TimeStatistic Medium

See Also
Performance data organization

Name	Key	Description	Granularity	Type	Level
Num creates	connectionPoolModule.numCreates	Total number of connections created	Per connection pool	CountStatistic	Low
Pool size	connectionPoolModule.poolSize	The size of the connection pool	Per connection pool	BoundedRangeStatistic	High
Free pool size	connectionPoolModule.freePoolSize	The number of free connections in the pool	Per connection pool	BoundedRangeStatistic	High
Num allocates	connectionPoolModule.numAllocates	Total number of connections allocated	Per connection pool	CountStatistic	Low
Num returns	connectionPoolModule.numReturns	Total number of connections returned	Per connection pool	CountStatistic	Low
Concurrent waiters	connectionPoolModule.concurrentWaiters	Number of threads that are currently waiting for a connection	Per connection pool	RangeStatistic	High
Faults	connectionPoolModule.faults	Total number of faults, such as timeouts, in the connection pool	Per connection pool	CountStatistic	Low
Num closes	connectionPoolModule.numDestroys	Number of times bean objects were freed	Per connection pool	CountStatistic	Low
Avg wait time (ms)	connectionPoolModule.avgWaitTime	Average waiting time in milliseconds until a connection is granted	Per connection pool	TimeStatistic	Medium
Avg use time (ms)	connectionPoolModule.avgUseTime	Average time a connection is used (Difference between the time at which the connection is allocated and returned. This includes the JDBC operation time.)	Per connection pool	TimeStatistic	Medium
Percent used	connectionPoolModule.percentUsed	Average percent of the pool that is in use	Per connection pool	RangeStatistic	High
Percent maxed	connectionPoolModule.percentMaxed	Average percent of the time that all connections are in use	Per connection pool	RangeStatistic	High
Prepared stmt cache discards	connectionPoolModule.prepStmtCacheDiscards	Total number of statements discarded by the LRU algorithm of the statement cache	Per connection pool	CountStatistic	Low
Num managed connections	connectionPoolModule.numManagedConnections	Number of ManagedConnection objects in use for a particular connection pool (apply to 5.0 DataSource only)	Per connection factory	CountStatistic	Low
Num connection handles	connectionPoolModule.numConnectionHandles	Number of Connection objects in use for a particular connection pool (apply to 5.0 DataSource only)	Per connection factory	CountStatistic	Low
JDBC time	connectionPoolModule.jdbcOperationTimer	Amount of time in milliseconds spent executing in the JDBC driver (includes time spent in JDBC driver, network and database)	Per data source	TimeStatistic	Medium