Monitoring the Database with the Release 4 Alert Monitor (Inform

Monitoring the Database with the Release 4 Alert Monitor (Informix)

Use

Using the Release 4 alert monitor, you can monitor the following database alerts:

Space management – reorganization and space monitoring

DB system check – consistency and profile

Backup/restore

The alerts described in this section are all triggered automatically from DB System Checks in CCMS (Informix).

Prerequisites

Changing the default thresholds

Although SAP recommends that you do not normally change the default thresholds, you can set thresholds yourself for most of the database alerts.

Deactivating an alert

You can deactivate an alert, but only do this for a particular reason and for a short time.

For more information, see Configuring DB System Checks in CCMS (Informix).

Procedure

Start the Release 4 alert monitor. Refer to Starting the Alert Monitor.

Choose SAP CCMS Overview Monitors.

Choose Entire System.

Open the Database monitoring tree element (MTE).

As well as the alerts described below, you can still find the old alerts from R/3 Release 3.1 in the tree structure under the MTE Database Alerts 3.1. For more information on the old alert monitor, see Alerts: Overview. For more information on setting the alert thresholds for Informix, see Informix.

For each R/3 instance, the alerts are displayed with color coding to indicate severity. The following alerts are possible in the Database MTE:

MTE	Meaning	For more information, see
SpaceManagement	Monitors the space situation in your database	Management of Database Growth
Reorganization	Checks if reorganization or application data archive required, due to tables running out of extents or running out of allocated pages	Reorganization with SAPDBA Application Data Archiving Analyzing Tables by Fill Level, Size, and Extents with SAPDBA
SpaceMonitoring	Checks if dbspace fill level OK and if tables can be extended correctly	Listing Dbspaces with SAPDBA Analyzing Tables for Critical Next Extent Size with SAPDBA See also next step.
DBSystemCheck	Checks key aspects of your database system	DB System Checks in CCMS (Informix)
DB Consistency	Checks if chunk sizes are within limit, if raw devices are overlapping, and if logging mode OK	Listing Chunks with SAPDBA Logging Mode with SAPDBA
DB Profile	Checks value of settings in the ONCONFIG file	Editing the ONCONFIG File for ON-Archive
Backup	Checks aspects affecting database backup and archive	Database Backup (ON-Bar) Archive (ON-Archive and ontape)
Restore	Checks number of chunks for a dbspace	Listing Chunks with SAPDBA

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

If you have the SpaceMonitoring alert for a dbspace, choose Start analysis tool to extend the dbspace. Refer to Extending a Dbspace with CCMS.

Result

By using the Release 4.0 database alert monitor continually during productive database operation, you can find out quickly and easily whether your database has problems. The result is a more highly tuned database and reduced system downtime.