Monitoring the Database Using the Alert Monitor

Using the alert monitor, you can monitor the following objects:

• SpaceManagement
• Performance
• Health
• Consistency

Procedure

1. To call the alert monitor, choose Tools ®
CCMS ® Control/Monitoring ® Alert Monitor. Alternatively, call transaction RZ20.
2. Expand SAP CCMS Monitor Templates.
3. Choose Entire System.
4. Open the MTE (monitor tree element) Database. The system displays the following monitoring objects:

Monitoring Object	Task:
SpaceManagement	Monitors the space situation in your database. State on Disk (iSeries)
Performance	Monitors database performance. Database Monitor (iSeries)
Health	Monitors ASP usage. In the standard configuration of your SAP System, the database library is located in ASP1.The journal receivers are in ASP2. This separation avoids disk failure. When the ASP2 is filling, the system starts storing journals in ASP1. This is called ASP overflow. ASP overflow is dangerous because it does not ensure possible data recovery.
Consistency	Monitors the database tables and checks for missing unique indexes (it also takes the SAP exception table into account). Monitors consistency between ABAP Dictionary and database. There are no thereshold values to be maintained for this monitoring object. Green: Unique indexes exist for all database tables. Red: At least one unique index for a database table missing. Actions: Create the missing unique indexes in the ABAP Dictionary (transaction SE11) in your SAP System.

To display up-to-date and detailed information about what the alerts mean and how you should react, use the online help in the SAP System.

Result

If you use the alert monitor continually during production operation, you can find out quickly and easily whether your database has problems. The result is a more highly tuned database and reduced downtime.