Monitoring database health and availability

With the Data Studio web console, you can view database health information at several levels of detail: from a summary view of the overall health and availability of all your databases, to the details of a particular problem on a specific database.
Health Summary
This page provides you with a health and availability overview. All connected databases are listed. The status of key health indicators for these databases is displayed. Potential areas for concern are identified by critical (Critical alerts icon.) and warning (Warning alerts icon.) alerts in the Health Summary table. The alert categories include:
  • System: Data Server Status
  • Database
    • Connections
    • Storage
    • Recovery

Health and availability information is available for several predefined alerts.

Alert List
This page provides an overview of current and recent alerts during the time period that you specify for the database. Detailed information for individual alerts is available for each of the listed items. Suggested actions are also available to help you solve the problems that are causing a specific alert.

The alert list can provide you with answers to questions like, "What happened when I was out for lunch?" or "What happened while I was away for the weekend?"

Current Application Connections
This page displays the application connections for a database, and indicates the status of the connection by idle time. This page also provides information about the connection, such as rows read and rows written.
Depending on the connection status you can choose to force an application. For example, to allow for system maintenance or to enhance system performance you can force an application connection that has been idle for a long time.
Current Table Spaces
This page displays information about the table spaces and table space containers for the selected database.
Current Utilities
This page displays status information about utilities (such as RUNSTATS and BACKUP) that are currently operating on the database.
Data Sharing Members
This page displays the DB2® for z/OS® subsystems that are members of the same data sharing group for the selected database connection.
z/OS System Log
This page displays system log entries for a DB2 for z/OS subsystem or for a group of data sharing members. You can use this page to view the most recent system log entries or specify a number of log entries to show for a point in time.
Health Alerts Configuration
You can turn off monitoring of any database or alert, or change the threshold values that cause an alert to be displayed. Configure alerts for health and availability monitoring by using one of the following methods:
  • Click the Configure alerts icon. icon in a column header in the Health Summary to open the alert configuration table for that alert category across all databases.
  • Select a database and click the Configure Alerts button to open the alert configuration table for all alert categories for that database.
  • Click an alert in the Health Summary and select an alert from the list that opens. Click the Configure button to open the alert configuration window for that alert category.
  • Select an alert from the Alert List page and click the Configure button to access the alert configuration window.
Alert Notification
Use this page to manage subscriptions to alerts. You can configure alert notifications by alert type, severity, and database. You can also define alert notification parameters such as email addresses, SNMP trap generation, and alert frequency.

Feedback