Show TOC

Database Alert MonitorLocate this document in the navigation structure

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.

Note

A liveCache Alert Monitor has been set up for SAP liveCache technology. The documentation for the Database Alert Monitor usually also applies for the liveCache Alert Monitor. If there are functional differences, these are explained.

Prerequisites
Features

You can use the following start options:

  • Alert Monitor

    For the SAP MaxDB database instance that is the basis of the current SAP Web AS system: In the Database Assistant, choose  Start of the navigation path Alert Monitor Next navigation step Database Next navigation step MaxDB End of the navigation path ( Alert Monitor).

    For all other SAP MaxDB databases: In the database assistant, choose Start of the navigation path Alert Monitor Next navigation step MaxDB Monitoring Next navigation step OLTP Next navigation step <name of the database connection> End of the navigation path.

    The Alert Monitoring is activated and the database connection 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 SAP MaxDB database instance that is the basis of the current SAP Web AS system: In CCMS Monitoring, choose Start of the navigation path SAP CCMS Monitor Templates Next navigation step Database Next navigation step MaxDB End of the navigation path.

    For all other SAP MaxDB databases: In CCMS Monitoring, choose Start of the navigation path SAP CCMS Monitor Templates for Optional Components Next navigation step MaxDB Monitoring Next navigation step OLTP Next navigation step <name of the database connection> End of the navigation path.

  • DBA Cockpit

    In the DBA Cockpit (transaction DBACOCKPIT), choose Start of the navigation path Alerts Next navigation step Alert Monitor (old/new version) End of the navigation path.

Activities

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 hierarchy 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 node in the monitoring tree:

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 puts production operation of the database 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

Run the report RSLVCALMON.

  1. Start the ABAP Editor (transaction SE38).

  2. Enter RSLVCALMON.

  3. Enter the name of the database connection.

As an alternative to starting the report, you can 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

Run the report RSLVCALMDEL.

  1. Start the ABAP Editor (transaction SE38).

  2. Enter the name RSLVCALMDEL.

  3. Enter the name of the database connection.

More Information