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.
- The attributes within this attribute group contain zeros for performance data if your site set configuration value Resource Data Collection Method to On Demand (for on-demand sampling) and you have not yet run applications that generate performance data. To report performance data in these attributes after installing and configuring the data collector, use the WebSphere administrative console to set the appropriate PMI instrumentation level.
- The Tivoli Enterprise Monitoring Agent is set by default to provide on-demand sampling; thus the attributes within this attribute group initially contain zeros until you select the workspace and then select it again later. Each time you select the workspace, these attributes are updated with the latest data.
For information about WebSphere PMI metrics, see WebSphere PMI Attribute Mapping.
Indicates J2EE application ID.
Indicates the average size of the pool based upon the number of free connections.
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.
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).
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).
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.
Indicates the number of Connection objects in use for a particular connection pool.
The number of managed connection objects in use for a particular EIS product name. Format is positive integer.
The number of connections allocated during the interval. Format is positive integer.
The number of connections created during the interval. Format is positive integer.
The number of connections released during the interval. Format is positive integer.
The sum of connections allocated and connections created during the interval. Format is positive integer.
The abbreviated name of the data source. Alphanumeric string. Maximum2 characters.
The name of the data source. Alphanumeric string.
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.
The length (in seconds) of the interval. Format is positive integer.
Indicates the amount of time spent running in the JDBC driver which includes time spent in the JDBC driver, network, and database.
The maximum number of connections that can be created in this connection pool. Format is positive integer.
The name of the system on which the server is running. The value format is an alphanumeric string, with a maximum of 256 characters.
The name of the server subnode. Alphanumeric string.
Indicates the size of the connection pool.
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.
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.
The bad percent of pool usage by application. Format is positive integer.
The fair percent of pool usage by application. Format is positive integer.
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).
The number of prepared statements discarded from the cache during the interval. Format is positive integer.
Indicates the size of the connection pool.
The number of connections that applications returned to the pool during the interval. Format is positive integer.
The number of connections (per second) returned since the previous sample. Format is decimal (formatted to 3 decimal places).
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.
The name of the application server. Alphanumeric string.
Type
Indicates the WebSphere resource category, which is used by the agent to modify the Instrumentation Level for transaction data collection.
Whether this row is a summary row of statistical totals collected for all the DB connection pools. Valid values are No and Yes.
The number of threads (per second) that timed out during the interval. Format is decimal (formatted to 3 decimal places).
The number of threads that timed out while waiting for a connection during the interval. Format is positive integer.
The total time (in milliseconds) the connection object used. Format is decimal (formatted to 3 decimal places).
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