hwroc
The number of objects that were reused from the pool.
coc
The number of objects that the IBM Data Server Driver for JDBC and SQLJ
created since the pool was created.
aooc
The number of objects that exceeded the idle time that was specified by
db2.jcc.maxTransportObjectIdleTime and were deleted from the pool.
rmoc
The number of objects that have been deleted from the pool since the pool was
created.
nbr
The number of requests that the IBM Data Server Driver for JDBC and SQLJ
made to the pool that the pool blocked because the pool reached its maximum
capacity. A blocked request might be successful if an object is returned to the
pool before the db2.jcc.maxTransportObjectWaitTime is exceeded and an
exception is thrown.
tbt
The total time in milliseconds for requests that were blocked by the pool. This
time can be much larger than the elapsed execution time of the application if
the application uses multiple threads.
sbt
The shortest time in milliseconds that a thread waited to get a transport object
from the pool. If the time is under one millisecond, the value in this field is
zero.
lbt
The longest time in milliseconds that a thread waited to get a transport object
from the pool.
abt
The average amount of time in milliseconds that threads waited to get a
transport object from the pool. This value is tbt/nbr.
tpo
The number of objects that are currently in the pool.
Application programming interfaces for monitoring the global
transport objects pool
You can write applications to gather statistics on the global transport objects pool.
Those applications create objects in the DB2PoolMonitor class and invoke methods
to retrieve information about the pool.
For example, the following code creates an object for monitoring the global
transport objects pool:
import com.ibm.db2.jcc.DB2PoolMonitor;
DB2PoolMonitor transportObjectPoolMonitor =
DB2PoolMonitor.getPoolMonitor (DB2PoolMonitor.TRANSPORT_OBJECT);
After you create the DB2PoolMonitor object, you can use methods in the
DB2PoolMonitor class to monitor the pool.
Related tasks
480 Application Programming Guide and Reference for Java
â„¢