JDBC connection pool data counters: WebSphere Application Server

JDBC connection pool data counters

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 JNDI name is used.

The JDBC connection pool counters are used to monitor the JDBC data sources performance. The data can be found by using the Tivoli Performance Viewer and looking under each application server. Click application_server > JDBC connection pool.

Data counter definitions

Name Description Version Granularity Type Level

creates Total number of connections created 3.5.5 and above per connection pool CountStatistic Low

avg pool size Average pool size 3.5.5 and above per connection pool BoundedRangeStatistic High

free pool size Average free pool size 5.0 per connection pool BoundedRangeStatistic High

allocates Total number of connections allocated 3.5.5 and above per connection pool CountStatistic Low

returns Total number of connections returned 4.0 and above per connection pool CountStatistic Low

avg waiting threads Number of threads that are currently waiting for a connection 3.5.5 and above per connection pool RangeStatistic High

connection pool faults Total number of faults, such as, timeouts, in connection pool 3.5.5 and above per connection pool CountStatistic Low

destroys Number of times bean objects were freed 3.5.5 and above per connection pool CountStatistic Low

avg wait time Average waiting time in milliseconds until a connection is granted 5.0 per connection pool TimeStatistic Medium

avg time in use Average time a connection is used (Difference between the time at which the connection is allocated and returned. This includes the JDBC operation time.) 5.0 per connection pool TimeStatistic Medium

percent used Average percent of the pool that is in use 3.5.5 and above per connection pool RangeStatistic High

percent maxed Average percent of the time that all connections are in use 3.5.5 and above per connection pool RangeStatistic High

Statement cache discard count Total number of statements discarded by the LRU algorithm of the statement cache 4.0 and above per connection pool CountStatistic Low

Number managed connections Number of ManagedConnection objects in use 5.0 per connection factory CountStatistic Low

Number connections Current number of connection objects in use 5.0 per connection factory CountStatistic Low

jdbcOperationTimer Amount of time in milliseconds spent executing in the JDBC driver (includes time spent in JDBC driver, network and database) 5.0 per data source TimeStatistic Medium

Name	Description	Version	Granularity	Type	Level
creates	Total number of connections created	3.5.5 and above	per connection pool	CountStatistic	Low
avg pool size	Average pool size	3.5.5 and above	per connection pool	BoundedRangeStatistic	High
free pool size	Average free pool size	5.0	per connection pool	BoundedRangeStatistic	High
allocates	Total number of connections allocated	3.5.5 and above	per connection pool	CountStatistic	Low
returns	Total number of connections returned	4.0 and above	per connection pool	CountStatistic	Low
avg waiting threads	Number of threads that are currently waiting for a connection	3.5.5 and above	per connection pool	RangeStatistic	High
connection pool faults	Total number of faults, such as, timeouts, in connection pool	3.5.5 and above	per connection pool	CountStatistic	Low
destroys	Number of times bean objects were freed	3.5.5 and above	per connection pool	CountStatistic	Low
avg wait time	Average waiting time in milliseconds until a connection is granted	5.0	per connection pool	TimeStatistic	Medium
avg time in use	Average time a connection is used (Difference between the time at which the connection is allocated and returned. This includes the JDBC operation time.)	5.0	per connection pool	TimeStatistic	Medium
percent used	Average percent of the pool that is in use	3.5.5 and above	per connection pool	RangeStatistic	High
percent maxed	Average percent of the time that all connections are in use	3.5.5 and above	per connection pool	RangeStatistic	High
Statement cache discard count	Total number of statements discarded by the LRU algorithm of the statement cache	4.0 and above	per connection pool	CountStatistic	Low
Number managed connections	Number of ManagedConnection objects in use	5.0	per connection factory	CountStatistic	Low
Number connections	Current number of connection objects in use	5.0	per connection factory	CountStatistic	Low
jdbcOperationTimer	Amount of time in milliseconds spent executing in the JDBC driver (includes time spent in JDBC driver, network and database)	5.0	per data source	TimeStatistic	Medium