com.ibm.websphere.pmi.stat

Interface WSJDBCConnectionPoolStats



  • public interface WSJDBCConnectionPoolStats
    WebSphere JDBC connection pool stats interface. JDBC connection pool stats are structured as follows in the PMI tree:

    <server>
    |
    |__JDBC Connection Pools+
      |
      |__<JDBC provider 1>+
        |
        |_Data source A
      |   |__<JDBC provider 2>+
        |
        |_Data source B

    + indicates logical group

    StatDescriptor is used to locate and access particular Stats in the PMI tree.
    Example:

    1. StatDescriptor that represents the JDBC provider 1 logical group: new StatDescriptor (new String[] {WSJDBCConnectionPoolStats.NAME, "JDBC provider 1"});
    • Field Summary

      Fields 
      Modifier and Type Field and Description
      static int AllocateCount
      Total number of connections allocated (CountStatistic).
      static int CloseCount
      Number of connections freed (CountStatistic).
      static int ConnectionHandleCount
      Number of Connection objects in use for a particular connection pool (CountStatistic).
      static int CreateCount
      Number of connections created (CountStatistic).
      static int FaultCount
      The number of connection timeouts in the pool.
      static int FreedCount
      Total number of connections returned to pool (CountStatistic).
      static int FreePoolSize
      The number of free connections in the pool (BoundedRangeStatistic).
      static int JDBCTime
      Amount of time in milliseconds spent executing in the JDBC driver (TimeStatistic).
      static int ManagedConnectionCount
      Number of ManagedConnection objects in use for a particular connection pool (CountStatistic).
      static java.lang.String NAME
      Stats name of the top level JDBC connection pool logical group in PMI tree.
      static int PercentMaxed
      Average percent of the time that all connections are in use (RangeStatistic).
      static int PercentUsed
      Average percent of the pool that is in use (RangeStatistic).
      static int PoolSize
      The size of connection pool (BoundedRangeStatistic).
      static int PrepStmtCacheDiscardCount
      Total number of statements discarded by the LRU algorithm of the prepared statement cache (CountStatistic).
      static int UseTime
      Average time a connection is used (TimeStatistic).
      static int WaitingThreadCount
      Number of threads that are currently waiting for a connection (RangeStatistic).
      static int WaitTime
      Average waiting time in milliseconds until a connection is granted (TimeStatistic).
    • Field Detail

      • NAME

        static final java.lang.String NAME
        Stats name of the top level JDBC connection pool logical group in PMI tree.

        <server>
        |
        |__JDBC Connection Pools+

        See Also:
        Constant Field Values
      • CreateCount

        static final int CreateCount
        Number of connections created (CountStatistic).
        See Also:
        Constant Field Values
      • CloseCount

        static final int CloseCount
        Number of connections freed (CountStatistic).
        See Also:
        Constant Field Values
      • AllocateCount

        static final int AllocateCount
        Total number of connections allocated (CountStatistic).
        See Also:
        Constant Field Values
      • FreedCount

        static final int FreedCount
        Total number of connections returned to pool (CountStatistic).
        See Also:
        Constant Field Values
      • PoolSize

        static final int PoolSize
        The size of connection pool (BoundedRangeStatistic).
        See Also:
        Constant Field Values
      • FreePoolSize

        static final int FreePoolSize
        The number of free connections in the pool (BoundedRangeStatistic).
        See Also:
        Constant Field Values
      • WaitingThreadCount

        static final int WaitingThreadCount
        Number of threads that are currently waiting for a connection (RangeStatistic).
        See Also:
        Constant Field Values
      • FaultCount

        static final int FaultCount
        The number of connection timeouts in the pool. (CountStatistic).
        See Also:
        Constant Field Values
      • PercentUsed

        static final int PercentUsed
        Average percent of the pool that is in use (RangeStatistic).
        See Also:
        Constant Field Values
      • PercentMaxed

        static final int PercentMaxed
        Average percent of the time that all connections are in use (RangeStatistic).
        See Also:
        Constant Field Values
      • UseTime

        static final int UseTime
        Average time a connection is used (TimeStatistic). (Difference between the time at which the connection is allocated and returned. This includes the JDBC operation time.)
        See Also:
        Constant Field Values
      • WaitTime

        static final int WaitTime
        Average waiting time in milliseconds until a connection is granted (TimeStatistic).
        See Also:
        Constant Field Values
      • ManagedConnectionCount

        static final int ManagedConnectionCount
        Number of ManagedConnection objects in use for a particular connection pool (CountStatistic). (Applies to V5.0 data sources only)
        See Also:
        Constant Field Values
      • ConnectionHandleCount

        static final int ConnectionHandleCount
        Number of Connection objects in use for a particular connection pool (CountStatistic). (Applies to V5.0 data sources only)
        See Also:
        Constant Field Values
      • PrepStmtCacheDiscardCount

        static final int PrepStmtCacheDiscardCount
        Total number of statements discarded by the LRU algorithm of the prepared statement cache (CountStatistic).
        See Also:
        Constant Field Values
      • JDBCTime

        static final int JDBCTime
        Amount of time in milliseconds spent executing in the JDBC driver (TimeStatistic). (includes time spent in JDBC driver, network, and database)
        See Also:
        Constant Field Values
IBM WebSphere Application ServerTM
Release 9.0