Database Alert Monitor 

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.

Prerequisites

Prerequisites

Alert Monitoring is activated.

Procedure

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.

·        CCMS Monitoring
For the OLTP database instance that is the basis of the current SAP Web AS system:
In CCMS Monitoring, choose SAP CCMS Monitor Templates ® Database ® MaxDB.
For all other OLTP database instances:
In CCMS monitoring, choose SAP CCMS Monitor Templates for Optional Components ® MaxDB Monitoring ® OLTP.

Expand the desired Database Alert Monitor.

Nodes

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 R/3 Consistency

·        Health

·        External Analysis Tools

Colors of the Alerts

·        Greendisplays 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).

Adding a Database Connection to the Database Alert Monitor

       1.      Activate the Alert Monitorings.

       2.      Execute the report RSLVCALMON.

                            a.      Start transaction SE38.

                            b.      Enter RSLVCALMON.

                            c.      Enter the name of the database connections.

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

       3.      If necessary, update the database alert monitor tree. To do this, choose Refresh and Invalidate Data Cache in the database alert monitor.

Deleting a Database Connection from the Database Alert Monitor

...

       1.      Deactivate alert monitoring.

       2.      Execute the report RSLVCALMDEL.

                            a.      Start transaction SE38.

                            b.      Enter RSLVCALMDEL.

                            c.      Enter the name of a database connection.

       3.      If necessary, update the database alert monitor tree. To do this, choose Refresh and Invalidate Data Cache in the database alert monitor.