DB2 Version 9.7 for Linux, UNIX, and Windows

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.