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 Views
- This page provides customizable views 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.
Alert views 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, and you
can define alert notification parameters such as email addresses,
SNMP trap generation, and alert frequency.
You can also manage
alert actions that run jobs when alerts are triggered.