EasyManuals Logo

IBM DB2 User Manual

IBM DB2
585 pages
To Next Page IconTo Next Page
To Next Page IconTo Next Page
To Previous Page IconTo Previous Page
To Previous Page IconTo Previous Page
Page #496 background imageLoading...
Page #496 background image
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
â„¢

Table of Contents

Questions and Answers:

Question and Answer IconNeed help?

Do you have a question about the IBM DB2 and is the answer not in the manual?

IBM DB2 Specifications

General IconGeneral
DeveloperIBM
Initial Release1983
LicenseProprietary
Written inC, C++
CategoryDatabase Management System (RDBMS)
Operating SystemLinux, Windows
Programming LanguagesC, C++
Data ModelsRelational
EditionsCommunity, Standard, Advanced
Key Featureshigh availability, scalability