Database Alert Monitor

Use

You can use the Database Alert Monitor to identify memory problems in good time, to check the security of your database system and to monitor performance.

If data collection methods are periodically scheduled, alerts are automatically updated, and forwarded to the monitoring tree. Analysis methods deliver additional information about the alert statuses, and auto-reaction methods can be configured for automatic reactions to new alerts.

Integration

You can use the following start options:

?     Alert-Monitor
For the OLTP database instance that is the basis of the current SAP Web AS system:
In the Database Assistant, choose Alert Monitor
® Database ® MaxDB.
For all other OLTP database instances:
In the Database Assistant, choose Alert Monitor
® MaxDB Monitoring ® OLTP.
The Alert Monitoring is activated and the database conn
ection has been added to the Database Alert Monitor.

?     CCMS Monitoring
If the Alert Monitoring is not activated, (for example, when accessing the Database Alert Monitor in the Database Assistant) you should activate the Alert Monitor and add the database connection to the Database Alert Monitor (see below: Managing Database Connections in the Database Alert Monitor).
For the OLTP database instance that is the basis of the current SAP Web AS system:
In CCMS Monitoring SAP CCMS Admin Workplace
® Database ® <SAPSID> ® MaxDB.
For all other OLTP database instances:
In CCMS monitoring, choose SAP CCMS Monitor Templates for Optional Components
® MaxDB Monitoring ® OLTP.

Prerequisites

Prerequisites

Features

If necessary, update the display for the Database Alert Monitor tree. To do this, choose Refresh and Invalidate Data Cache in the Database Alert Monitor.

Expand the desired Database Alert Monitor.

Node

Every monitored element of the database instance is displayed as part of a hierarchical tree (monitoring tree) and described as a monitoring tree element (MTE), or node. Online help (short and long texts) gives you the most important information about each node.

You can choose from the following displays for each database instance node in the monitoring tree:

?     Properties

?     Space Management

?     Performance

?     Backup/Recovery

?     SAP Consistency

?     Health

?     External Analysis Tools

Colors of the Alerts

?     Green displays mean that the database state is OK. The administrator does not need to intervene.

?     Yellow or red displays mean that this state is putting production operation of the database instance at risk. The administrator must take measures to find and eliminate the cause of the alert.

Data Collector

Data collectors usually collect data for more than one node. You can see an overview of the data collectors in the appropriate internal subtree. For information on the frequency of the data collections, see the long text for each node.

Analysis Methods

You can start the analysis methods of a node through the node itself (for example, by double-clicking it).

Managing Database Connections in the Database Alert Monitor

Calling up the Database Alert Monitor using the Database Assistant user menu usually activates the Alert Monitoring and the database connection is added to the Database Alert Monitor Tree.

It may be necessary to update the Database Alert Monitor display. To do this, choose Refresh and Invalidate Data Cache in the database alert monitor.

In some special cases you may choose or have to administer the database connection in the Database Alert Monitor manually. In these cases you can use the report RSLVCALMON.

Adding a Database Connection to the Database Alert Monitor

Execute the report RSLVCALMON.

...

       1.      Choose ABAP Editor (transaction SE38).

       2.      Enter RSLVCALMON.

       3.      Enter the name of the database connection.

As an alternative to starting the report, you could also start the central instance.

The Database Alert Monitor is started and the database connection is added. It may be necessary to update the Database Alert Monitor display. To do this, choose Refresh and Invalidate Data Cache in the Database Alert Monitor.

Deleting a Database Connection from the Database Alert Monitor

...

Execute the report RSLVCALMDEL.

       1.      Choose ABAP Editor (transaction SE38).

       2.      Enter RSLVCALMDEL.

       3.      Enter the name of a database connection.