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 (
) and warning (
) 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
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.