Displaying Alert Messages from Database System Check 

Use

Use the alert messages from the database system check to recognize existing and possible critical Oracle database situations in time.

Always deal with any alert messages from the database check system as quickly as possible. Alert messages with severity E are serious problems for which you must take immediate action.

Procedure

To display alert messages from the database system check, choose Tools ® CCMS ® DB Administration ® DB System Check ® Display alerts. Alternatively: Choose Transaction DB16 .

In the group box:

The alerts (warnings and errors) from the database system check is displayed in a table The table includes the following columns:

Severity of the alert message:

A : Exception due to a deviation from the SAP standard (for example, a parameter for a PROF alert message is not within the value range we recommend)

C : An error occurred, but it has been fixed in the meantime

E : Error (for errors of alert type DBA take immediate action)

W : Warning

Date of alert

Time of alert

Age (days) of alert

Alert message type (DBA, ORA and PROF) to which the parameters of the database system check are assigned For more information, see Configuring Database System Check

Parameter for the database system check For more information, see Alert Messages from Database System Check

Description of alert. This description is taken from the SAPDBA -check log. Long alert messages (such as those that contain lists of names) are displayed in shortened form. See the SAPDBA detail log or the Oracle alert log for the full message.

Activities

To automatically refresh the display of database operations, choose Settings ® Auto-refresh ® Activate. To deactivate automatic refresh of the display, choose Deactivate. To set the time interval for the refresh, choose Settings ® Auto-refresh ® Time Interval.

To start the database system check immediately, choose Start check

To configure the database system check, choose Configure check

To call the database operations monitor, choose Database operations monitor

To display detailed information about a line, place the cursor on the line and choose the Details on selected line icon

To display specific views (open alerts or all alerts), choose Settings ® View ® Standard or History. To set the time period for the view, choose Settings ® View ® Time period.

To display a print preview of the table, choose the Print view icon

To export the table to a different file format, choose the Export icon

To update the table display, choose the Read check results again icon

To manually delete a table entry, select the table entry and choose the Delete selected alert icon

To manually reset a completed error or warning alert, choose the Reset selected alert

To automatically delete table entries, choose Settings ® Auto-delete ® Activate Choose Deactivate to deactivate automatic delete. To set the time interval for the delete, choose Settings ® Auto-delete ® Time interval.

To print table entries, choose Print

To sort table entries, choose either Sort in ascending order or Sort in descending order

To search for table entries in the table, choose Find

To save all your settings (view, auto-refresh, and auto-delete), choose Settings ® Save.