DB Connection Pools workspace

This workspace displays information about the database connection pools associated with each application server.

You can use this workspace to monitor Java™ Database Connectivity (JDBC) performance for WebSphere® Application Server applications. This workspace displays data provided by the DB Connection Pools attributes.

Notes:
  • This workspace reports blanks for resource data on the first invocation if PMI data collection is configured for on-demand sampling (that is, if your site set configuration value Resource Data Collection Method to On Demand) or if you have not yet run applications that generate PMI resource data. To report resource data in this workspace after installing and configuring the Data Collector, use the WebSphere administrative console to set the appropriate PMI instrumentation level.
  • Because of the high overhead, the monitoring agent provides on demand sampling by default. To activate PMI monitoring, you must first select this workspace and then select it again later. Each time you select the workspace, it displays the data collected during the interval between selections.

The predefined workspace contains the following items:

  • Highest Average Pool Sizes bar chart, which shows the largest average size (that is, number of connections) for each database connection pool
  • Worst Wait Times bar chart, which shows the worst wait times (in milliseconds) for each database connection pool
  • Highest Allocation Rates bar chart, which shows the rate at which database connections are being made for each connection pool
  • DB Connection Pools report, which displays information about the database connection pool for each defined data source. The report also displays an aggregated value that aggregates over all data sources. For example, this report displays the number of threads waiting for a connection and the number of connections created and released

Accessing the DB Connection Pools workspace

To access this workspace, complete the following steps:

  1. In the Navigator, expand Windows Systems, Linux® Systems, z/OS Systems, or UNIX Systems, as appropriate for the node you are monitoring.
  2. Within the node list, expand the entry that corresponds to the node you want to select.
  3. Within that node list of monitored applications, expand the list of WebSphere agents.
  4. Within the list of available agents, expand the WebSphere Application Server entry of your choice.
  5. Within that server list of available WebSphere Application Server workspaces, click the DB Connection Pools entry.

Selected DB Connection Pool - History workspace

The Selected DB Connection Pool - History workspace displays historical information that corresponds to the information in the DB Connection Pools workspace for a selected connection pool. Historical information is collected over a specific time span. See the online help for IBM® Cloud Pak System Software Monitoring Portal for a detailed explanation of historical reporting.

Accessing the Selected DB Connection Pool - History workspace

To access this workspace from the DB Connection Pools workspace, use one of the following procedures:

  • From the DB Connection Pools report, click the link icon to the left of any row; then, from the menu, click Selected DB Connection Pool - History.
  • From the Highest Average Pool Sizes bar chart, the Worst Wait Times bar chart, or the Highest Allocation Rates bar chart, click any bar; then, from the menu, click Link To > Selected DB Connection Pool - History.

Accessing the Managing Server Visualization Engine from the DB Connection Pools workspace

In the Tivoli Enterprise Portal access the DB Connection Pools workspace. You can use the Diagnostic Server Activity Display link to access the Managing Server Visualization Engine.

  1. In the DB Connection Pools window, click the choose link icon Choose link icon then click Diagnostic Server Activity Display. If this is your first time to access the Managing Server Visualization Engine during a session, you see a Welcome to the Application Monitor page.
  2. Depending on the user setup configuration in your environment you may or may not have to type your Managing Server Visualization Engine User Name and Password. If you do, you only need to log in using your User Name and Password once per session.
  3. Click OK to display the Server Activity Display page in the Managing Server Visualization engine. You can use link to diagnose application problems, for example, slow transactions or high response times.
  4. The results relate directly to the context from where you launched the link in the Cloud Pak System Software Monitoring Portal. For more information about using the Server Activity Display page and additional features, refer to the Composite Application Manager help within the Managing Server Visualization Engine Interface.
  5. To return to the previous workspace in the Cloud Pak System Software Monitoring Portal interface at any time choose from the following options:
    • From the Cloud Pak System Software Monitoring Portal desktop client, click the back arrow on your web browser.
    • From the Cloud Pak System Software Monitoring Portal browser client, click the browser back arrow.