J2C Connection Pools attributes
The attributes provide J2C connection pool information.
The J2C Connection Pools attribute group provides information about connectors that adhere to J2C, the WebSphere® Application Server implementation of the J2C architecture.
Data counters for this category contain usage information about the J2C architecture that enables enterprise beans to connect and interact with procedural backend systems, such as Customer Information Control System (CICS®) and Information Management System (IMS). Examples include the number of managed connections or physical connections and the total number of connections or connection handles.
The attributes within this group are used to build the J2C Connection Pools workspace.
- 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 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.
Application ID Indicates J2EE application ID.
Average Free Connections The average number of free Managed Connections for the interval. The valid format is a 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 Pool Size The average number of Managed Connections for the interval. The valid format is a 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) that connections are in use (measured from when the connection is allocated to when it is returned). The valid format is a decimal (formatted to 3 decimal places).
Average Wait Time (ms) The average waiting time (in milliseconds) until a connection is granted for the interval. The valid format is a decimal (formatted to 3 decimal places).
Concurrent Waiting Threads The average number of threads concurrently waiting for a connection for the interval. The valid format is a positive integer. 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 rate (per second) of application connections allocated from Managed Connections for the sampling interval. The valid format is a decimal (formatted to 3 decimal places).
Connection Creation Rate (per sec) The rate (per second) of Managed Connections created for the sampling interval. The valid format is a decimal (formatted to 3 decimal places).
Connection Destruction Rate (per sec) The rate (per second) of Managed Connections destroyed for the sampling interval. The valid format is a decimal (formatted to 3 decimal places).
Connection Factory Name The name of the connection factory. The valid format is an alphanumeric string, with a maximum of 256 characters.
Connection Handles The number of open application connections that have been allocated from the managed connections. The valid format is a positive integer.
Connection Pool Timeout Rate (per sec) The rate (per second) of connection pool timeouts for the sampling interval. The valid format is a decimal (formatted to 3 decimal places).
Connection Pool Timeouts The number of faults, such as timeouts, in connection pools for the sampling interval. The valid format is a positive integer.
Connection Return Rate (per sec) The rate (per second) of allocated application connections that have been returned for the sampling interval. The valid format is a decimal (formatted to 3 decimal places).
Connections Allocated The number of application connections allocated from Managed Connections. The valid format is a positive integer.
Connections Created The total number of Managed Connections created during the sampling interval. The valid format is a positive integer.
Connections Destroyed The number of Managed Connections destroyed during the sampling interval. The valid format is a positive integer.
Connections Granted The number of Managed Connections granted during the interval. The valid format is a positive integer.
Connections Returned The number of allocated application connections that have been returned (closed) during the sampling interval. The valid format is a positive integer.
Connections Used The number of Managed Connection objects available in a particular connection pool; this number includes all Managed Connection objects that have been created but not destroyed. The valid format is a positive integer.
Factory Label The abbreviated name of the connection factory. The valid format is an alphanumeric string, with a maximum of 32 characters.
Instrumentation Level The instrumentation level for the J2C connection pools. For WebSphere Version 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 Time The length (in seconds) of the sampling interval. The valid format is a positive integer.
Maximum Pool Size The maximum number of managed connections that can be created in this connection pool (blank for each individual managed connection). The valid format is a positive integer.
Node Name The name of the system on which the server is running. The valid format is an alphanumeric string, with a maximum of 128 characters.
Origin Node The name of the server subnode. The valid format is an alphanumeric string, with a maximum of 128 characters.
Percent of Time Pool at Max The average percent of the time that all connections are in use for the interval. The valid format is a 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. The valid format is a positive integer.
Percent Used Fair The fair percent of pool usage by application. The valid format is a positive integer.
Percent Used Good The good percent of pool usage by application. The valid format is a positive integer.
Pool Used (%) The average percent of the pool that is in use for the interval. The valid format is a 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.
Row Number The number of the row within the report, which corresponds to a bar in the Highest Miss Rates bar chart. The valid format is a positive integer.
Sample Date and Time The date and time the monitoring 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:
| 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 WebSphere Application Server. The valid format is an alphanumeric string, with a maximum of 256 characters.
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 J2C Connections Whether this row is a summary row of statistical totals collected for all the J2C connection pools. Valid values are No and Yes.
Total Usage (ms) The total time (in milliseconds) the connection object used. The valid format is a decimal (formatted to 3 decimal places).
Total Wait (ms) The total time (in milliseconds) the connection object waited. The valid format is a decimal (formatted to 3 decimal places).