DB2PoolMonitor class
The com.ibm.db2.jcc.DB2PoolMonitor class provides methods for monitoring the global transport objects pool that is used for the connection concentrator and sysplex workload balancing.
DB2PoolMonitor fields
The following fields are defined only for the IBM® Data Server Driver for JDBC and SQLJ.
- public static final int TRANSPORT_OBJECT = 1
- This value is a parameter for the DB2PoolMonitor.getPoolMonitor method.
DB2PoolMonitor methods
The following methods are defined only for the IBM Data Server Driver for JDBC and SQLJ.
- agedOutObjectCount
- Format:
public abstract int agedOutObjectCount()
Retrieves the number of objects that exceeded the idle time that was specified by db2.jcc.maxTransportObjectIdleTime and were deleted from the pool.
- createdObjectCount
- Format:
public abstract int createdObjectCount()
Retrieves the number of objects that the IBM Data Server Driver for JDBC and SQLJ created since the pool was created.
- getMonitorVersion
- Format:
public int getMonitorVersion()
Retrieves the version of the DB2PoolMonitor class that is shipped with the IBM Data Server Driver for JDBC and SQLJ.
- getPoolMonitor
- Format:
public static DB2PoolMonitor getPoolMonitor(int monitorType)
Retrieves an instance of the DB2PoolMonitor class.
Parameter descriptions:- monitorType
- The monitor type. This value must be DB2PoolMonitor.TRANSPORT_OBJECT.
- heavyWeightReusedObjectCount
- Format:
public abstract int heavyWeightReusedObjectCount()
Retrieves the number of objects that were reused from the pool.
- lightWeightReusedObjectCount
- Format:
public abstract int lightWeightReusedObjectCount()
Retrieves the number of objects that were reused but were not in the pool. This can happen if a Connection object releases a transport object at a transaction boundary. If the Connection object needs a transport object later, and the original transport object has not been used by any other Connection object, the Connection object can use that transport object.
- longestBlockedRequestTime
- Format:
public abstract long longestBlockedRequestTime()
Retrieves the longest amount of time that a request was blocked, in milliseconds.
- numberOfConnectionReleaseRefused
- Format:
public abstract int numberOfConnectionReleaseRefused()
Retrieves the number of times that the release of a connection was refused.
- numberOfRequestsBlocked
- Format:
public abstract int numberOfRequestsBlocked()
Retrieves 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.
- numberOfRequestsBlockedDataSourceMax
- Format:
public abstract int numberOfRequestsBlockedDataSourceMax()
Retrieves 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 the maximum for the DataSource object.
- numberOfRequestsBlockedPoolMax
- Format:
public abstract int numberOfRequestsBlockedPoolMax()
Retrieves the number of requests that the IBM Data Server Driver for JDBC and SQLJ made to the pool that the pool blocked because the maximum number for the pool was reached.
- removedObjectCount
- Format:
public abstract int removedObjectCount()
Retrieves the number of objects that have been deleted from the pool since the pool was created.
- shortestBlockedRequestTime
- Format:
public abstract long shortestBlockedRequestTime()
Retrieves the shortest amount of time that a request was blocked, in milliseconds.
- successfullRequestsFromPool
- Format:
public abstract int successfullRequestsFromPool()
Retrieves the number of successful requests that the IBM Data Server Driver for JDBC and SQLJ has made to the pool since the pool was created. A successful request means that the pool returned an object.
- totalPoolObjects
- Format:
public abstract int totalPoolObjects()
Retrieves the number of objects that are currently in the pool.
- totalRequestsToPool
- Format:
public abstract int totalRequestsToPool()
Retrieves the total number of requests that the IBM Data Server Driver for JDBC and SQLJ has made to the pool since the pool was created.
- totalTimeBlocked
- Format:
public abstract long totalTimeBlocked()
Retrieves 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.