IBM Tivoli Composite Application Manager for Application Diagnostics, Version 7.1.0.1

DB Connection Pools attributes

The DB Connection Pools attributes provide information about the database connection pool for each defined data source, and an aggregated value that aggregates over all data sources.

Examples of DB Connection Pools include; the number of threads waiting for a connection and the number of connections created and released. Use the DB Connection Pools attributes to analyze JDBC performance for WAS applications. The attributes within this group are used to build the DB Connection Pools and the Pool Analysis workspaces.

For information about WebSphere PMI metrics, see WebSphere PMI Attribute Mapping.

Application ID

Indicates J2EE application ID.

Average Free Pool Size

Indicates the average size of the pool based upon the number of free connections.

Average Pool Size

The average size of the pool (based upon the number of connections) during the interval. Format is decimal (formatted to 3 decimal places). This value is an average of several values collected over an interval. The interval can be either between this time and the previous time you activated this workspace, or fixed (normally 60 seconds), depending on the configuration of the monitoring agent.

Average Usage Time (ms)

The average time (in milliseconds) a connection was in use; blank if no transactions are completed during the interval. Format is decimal (formatted to 3 decimal places).

Average Wait Time (ms)

The average time (in milliseconds) a client waited for a connection; blank if no transactions are completed during the interval. Format is decimal (formatted to 3 decimal places).

Average Waiting Threads

The average number of threads waiting for a connection during the interval. Format is decimal (formatted to 3 decimal places). This value is an average of several values collected over an interval. The interval can be either between this time and the previous time you activated this workspace, or fixed (normally 60 seconds), depending on the configuration of the monitoring agent.

Connection Allocation Rate (per sec)

The connections allocated (per second) for the interval since the previous sample. Format is decimal (formatted to 3 decimal places).

Connection Creation Rate

(per sec)

The connections created (per second) during the interval. Format is decimal (formatted to 3 decimal places).

Connection Destruction Rate

(per sec)

The connections released (per second) during the interval. Format is positive integer.

Connection Handle

Indicates the number of Connection objects in use for a particular connection pool.

Connection Used

The number of managed connection objects in use for a particular EIS product name. Format is positive integer.

Connections Allocated

The number of connections allocated during the interval. Format is positive integer.

Connections Created

The number of connections created during the interval. Format is positive integer.

Connections Destroyed

The number of connections released during the interval. Format is positive integer.

Connections Granted

The sum of connections allocated and connections created during the interval. Format is positive integer.

Datasource Label

The abbreviated name of the data source. Alphanumeric string. Maximum2 characters.

Datasource Name

The name of the data source. Alphanumeric string.

Instrumentation Level

The instrumentation level for the database connection pool for the data source. For WebSphere 5, the valid values are None, Low, Medium, High, and Maximum; for WebSphere 6 or higher, the valid values are None, Basic, Extended, All, Custom. Blank if no instrumentation level is set.

Interval (sec)

The length (in seconds) of the interval. Format is positive integer.

JDBC Time (ms)

Indicates the amount of time spent running in the JDBC driver which includes time spent in the JDBC driver, network, and database.

Maximum Pool Size

The maximum number of connections that can be created in this connection pool. Format is positive integer.

Node Name

The name of the system on which the server is running. The value format is an alphanumeric string, with a maximum of 256 characters.

Origin Node

The name of the server subnode. Alphanumeric string.

Pool Size

Indicates the size of the connection pool.

Percent of Time Pool at Max

The average percentage of time the number of connections in the pool reached the maximum number during the interval. Format is decimal (formatted to 3 decimal places). This value is an average of several values collected over an interval. The interval can be either between this time and the previous time you activated this workspace, or fixed (normally 60 seconds), depending on the configuration of the monitoring agent.

Percent Used

The average percentage of the connection pool in use during the interval. Format is decimal (formatted to 3 decimal places). This value is an average of several values collected over an interval. The interval can be either between this time and the previous time you activated this workspace, or fixed (normally 60 seconds), depending on the configuration of the monitoring agent.

Percent Used Bad

The bad percent of pool usage by application. Format is positive integer.

Percent Used Fair

The fair percent of pool usage by application. Format is positive integer.

Percent Used Good

The good percent of pool usage by application. Format is positive integer.

Prep Statement Cache Discard Rate

(per sec)

The cache discards (per second) of prepared statements during the interval. Format is decimal (formatted to 3 decimal places).

Prep Statement Cache Discards

The number of prepared statements discarded from the cache during the interval. Format is positive integer.

Pool Size

Indicates the size of the connection pool.

Return Count

The number of connections that applications returned to the pool during the interval. Format is positive integer.

Return Rate (per sec)

The number of connections (per second) returned since the previous sample. Format is decimal (formatted to 3 decimal places).

Sample Date and Time

The date and time the Tivoli Enterprise Management Agent collected the data. The valid format is a 12-character timestamp. For the STR and SCAN functions, the format is MM/DD/YY HH:MM:SS; the following table shows the values contained in this character string:


Format of the 12-character timestamp

Character String Meaning
MM Month
DD Day
YY Year
HH Hour
MM Minute
SS Second

Example: 09/13/06 18:32:03 indicates the data was collected on September 13, 2006, at 18:32:03.

This attribute was designed for logging and reporting data-collection times rather than for creating situations. To specify a time and date for comparison and testing, use attributes from the Universal Time or Local Time groups.

Server Name

The name of the application server. Alphanumeric string.

Set Instrumentation Level

Type

Indicates the WebSphere resource category, which is used by the agent to modify the Instrumentation Level for transaction data collection.

Summary of All DB Connections

Whether this row is a summary row of statistical totals collected for all the DB connection pools. Valid values are No and Yes.

Thread Timeout Rate (per sec)

The number of threads (per second) that timed out during the interval. Format is decimal (formatted to 3 decimal places).

Threads Timed Out

The number of threads that timed out while waiting for a connection during the interval. Format is positive integer.

Total Usage (ms)

The total time (in milliseconds) the connection object used. Format is decimal (formatted to 3 decimal places).

Total Wait (ms)

The total time (in milliseconds) the connection object waited. Format is decimal (formatted to 3 decimal places).

Additional information:


Parent topic:

Attributes for ITCAM Agent for WebSphere Applications