Viewing the Instance Overview

The DB2 Database Instance Overview displays a summary view of the instance health. You drill down further to carry out root cause analysis of various performance issues. To access the Instance Overview, drill down to Databases Dashboard > Instance Overview. To open the Instance Overview, from the Databases dashboard, find the instance you want to explore and click the instance name. The Databases > Overview dashboard opens with a summary of the selected instance. From here, you can drill down to metrics on memory allocation and perform configuration tasks. The Instance Overview provides metrics on the overall status of the selected instance.

The following summary and dashboard pages are provided:

Summary

By default, the Summary page view is displayed on the Instance Overview. The Summary page contains the following embedded panes:

Status

The Status pane displays metrics that provide an overview of the current state of the DB2 instance. It is at the top of the Instance Overview.

Description of the pane

Following data is displayed on the pane:

  • Sessions (no.)- The total number of active and inactive sessions within the instance.
  • CPU (%)- Total is the average CPU usage of all the underlying hosts on which the instance resides. DB2 is the total CPU usage by all DB2 processes running on the host.
  • Memory (%)- Total is the average memory usage of all the underlying hosts on which the instance resides. DB2 is the total memory usage by all DB2 processes running on the host.
  • Instance Information- The configuration information for the instance (including the product version and whether the product is licensed). Click the icon for the configuration information.
  • Active Databases- The total number of local databases within the instance that have applications connected.
  • Active Members- The total number of active members within the instance.
  • Up since- The date and time the instance was started.
  • Status- Whether the instance is active.
  • Availability- The current availability of the instance.
  • pureScale only- Active Members- Number of nodes in the pureScale environment.
  • pureScale only- Active CF- Displays information about configured CF nodes and their states.
  • pureScale only- pureScale Alerts- Total number of alerts DB2 reported on the pureScale environment.

Clicking a data point on any of the three charts displays a pop-up that provides additional, related information. Clicking the icon next to the Active Databases or Active Members metric displays a pop-up that provides additional information. Clicking the icon next to the Availability metric displays a pop-up that provides additional, related information.

Storage

The Storage pane provides current storage information for the entire instance. It is at the left of the Instance Overview.

Description of the pane

Following data is displayed on the pane:

  • Fixed storage- The total disk space that is available for use by fixed-size tablespaces and the disk space that is still free to be used by fixed-size tablespaces.
  • Auto storage- The total file system space that is available for the instance to use to carry out auto storage tablespace operations. Also, the file system space that is still free for the instance to use to carry out auto storage tablespace operations. Clicking the icon below either of the charts displays a pop-up that provides additional, related information.

Agents

The Agents pane provides registered and stolen agents information for the entire instance. It is located in the middle of the Instance Overview.

Description of the pane Following data is displayed on the pane:

  • Agents Registered- Displays the current agents registered to the instance, and the average agents registered to the instance over the course of the selected time range.
  • Agents Stolen- Displays the current agents stolen from the instance, and the average agents stolen from the instance over the course of the selected time range.

Clicking the icon next to either of the metrics displays a pop-up that provides additional, related information.

FCM | pureScale CF

The FCM pane displays FCM metrics for a partitioned instance. It is at the left and in the middle of the Instance Overview. Following data is displayed on the pane:

Description of the pane — FCM Following data is displayed on the pane:

  • FCM Sent (page/s)- The total number of FCM buffer pages sent from the current node to the remote node, over the course of the selected time range.
  • FCM Received (page/s)- The total number of FCM buffer pages received by the current node from the remote node, over the course of the selected time range.

Clicking the icon next to either of the metrics displays a pop-up that provides additional, related information. When an instance is hosted in a DB2 pureScale environment, you can click the pureScale CF link to see metrics about the cluster cache facility (CF).

Description of the pane — pureScale CF

Following data is displayed on the pane:

  • Current Primary ID- The ID of the CF component.
  • CPU Usage- Percentage of overall CPU usage on the CF machine.
  • Current Host- The current host of the selected DB2 instance. In a pureScale environment, the host can change depending on load.
  • Memory Utilization- Percentage of overall memory usage on the CF component.

Clicking the icon next to either of the metrics displays a pop-up that provides additional, related information.

Reports

The Reports pane provides access to the Executive Workload Summary Report, which is a workload overview of the instance and of each database. It is at the bottom left of the Instance Overview. Click the Executive Summary Report link to access the report.

History

The History pane displays the instance activity over the course of the selected time range. It is at the upper right of the Instance Overview.

Description of the pane

Following data is displayed on the pane: -Top Database Workload- The top three (if available) database workloads, over the course of the selected time range.

  • Top Database Request Time- The top three (if available) database total request times and wait request times, over the course of the selected time range.

Clicking a data point on the “Top Database Workload” chart displays a pop-up that provides more detailed information about the data point. Clicking a data point on a “Top Database Request Time” chart displays a popup that provides additional, related information. Clicking the link below any of the “Top Database Request Time” charts takes you to the corresponding Database Overview.

Alarms

The Alarms pane displays the total number of fatal, critical, and warning alarms that are currently outstanding against the instance. It is at the lower right of the Instance Overview.

Description of the pane

Following data is displayed on the pane:

  • Fatal- The total number of fatal alarms that are currently outstanding against the instance.
  • Critical- The total number of critical alarms that are currently outstanding against the instance.
  • Warning- The total number of warning alarms that are currently outstanding against the instance.

Clicking either of the three numbers opens the Outstanding Alarm(s) dialog box, which provides a list of the outstanding alarms and a brief description of each. Clicking any of the rows in the Outstanding Alarm dialog box opens the Alarm dialog box, which provides detailed information about the associated alarm.

Memory Dashboard

The Memory view provides metrics on how the databases in the instance use memory. On the Instance Overview, click Memory. This Overview contains the following embedded views:

DB Memory and Pool Breakdown

Shows how the total memory available for the instance is allocated to the database and CF pools.

Description of the Pane

Following data is displayed on the pane:

  • DB Memory- Displays the total memory allocated to the selected instance and its databases in a stacking area chart. For pureScale environments, also shows primary and backup CF allocations.
  • Pool Breakdown- Displays the total memory allocated to the selected instance and its databases as a pie chart. For pureScale environments, also shows primary and backup CF allocations.
Instance Manager tab

Shows where the instance gets its memory. Description of the Pane

Following data is displayed on the pane:

  • Instance Manager Memory- Displays the total memory available to the instance.
  • Pool Allocated Size- Displays the pools that contribute to the memory for the instance as a stacking area chart.
  • Instance Manager Breakdown- Displays the pools that contribute to the memory for the instance as a pie chart.
  • Pool Name- The name of the memory pool.
  • Utilization %- The percentage of configured allocated memory that is in use.
  • Allocation- The average allocated size (in KB) of a memory pool.
  • Config Size- The internally configured size (in KB) of a memory pool in the DB2 database system.
  • Alarm- The alarm count and state of the memory pool. Click an alarm count to view information about the alarm on the Outstanding Alarms dialog box.
Databases tab

Shows memory utilization by database.

Description of the Pane Following data is displayed on the pane:

  • Databases Memory- Displays the total memory allocated to the databases in the instance as a stacking area chart.
  • Databases Breakdown- Displays the total memory allocated to the databases in the instance as a pie chart.
  • Name- The name of the databases in the selected instance.
  • Utilization %- The percentage of configured allocated memory that is in use.
  • Allocation- The average allocated size (in KB) of memory allocated to the database.
  • Config Size- The internally configured size (in KB) of memory allocated to the database.
  • Alarm- The alarm count and state of the database. Click an alarm count to view information about the alarm on the Outstanding Alarms dialog box.
Primary CF tab

Displayed for pureScale environments only. Shows how the CF memory is allocated.

Description of the Pane

Following data is displayed on the pane:

  • Primary CF Memory- Displays the total cluster cache facility (CF) memory available to the instance and a breakdown of how the cache is allocated for locks, GBP, SCA, and other.
  • CF Pool Allocation Breakdown- Displays a breakdown of how the CF pool is allocated for locks, GBP, SCA, and other as a pie chart.
  • Pool Name- The name of the buffer pools in the CF component.
  • Utilization %- The percentage of configured allocated memory that is in use.
  • Allocation- The average allocated size (in KB) of a buffer pool.
  • Config Size- The internally configured size (in KB) of a buffer pool in the DB2 database system.
  • Alarm- The alarm count and state of the buffer pool. Click an alarm count to view information about the alarm on the Outstanding Alarms dialog box.
Backup CF tab

Displayed for pureScale environments only. Contains the same information as the Primary CF tab, but the monitoring data represents the backup cluster cache facility.