Displaying Alert Messages from Database System Check 

Use

This section describes how you can view alert messages for the Oracle database system check in the Computing Center Management System (CCMS).

Always deal with alert messages as quickly as possible. Alert messages with severity E (error) are serious problems for which we recommend you to take immediate action.

For more information on alerts raised here, see Database Health Alerts.

Procedure

...

       1.      Choose Administration ® CCMS ® DB Administration ® DB System Check ® Display alerts. Alternatively, choose transaction DB16.

The system shows the following display:

Screen Area	Field	Description
Check results	Red light	Number of error alerts
	Yellow light	Number of warning alerts
	Gray light	Number of exception alerts, that is, where there is a deviation from the SAP standard value
	Total	The sum of errors, warnings, and exceptions.
Settings	View the last	Controls the period for which the alerts are displayed
	Refresh every	Controls the refresh interval for the alerts
	Delete after	Controls the period after which alerts are deleted
Alert table	Level	Severity of the alert message: E: Error (for errors of alert type DBA take immediate action) W: Warning 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
	Date	Date of alert
	Time	Time of alert
	Days	Age in days of alert
	Type	Alert message type (DBA, DBO, ORA and PROF) to which the parameters of the database system check are assigned For more information, see Configuring Database System Check.
	Name	The technical name of the condition. Type DBA, see BRCONNECT Default Conditions for Database Administration. Type DBO, see BRCONNECT Default Conditions for Database Operations. Type ORA, see “Oracle Messages” in Database Health Alerts. Type PROF, see “Profile Parameters” in Database Health Alerts.
	Object	An object-specific alert of type DBA or DBO.
	Number	Number of alerts of the same kind
	Description	Description of the alert

       2.      You can perform the following actions:

¡        Refreshing the alert display

Choose Refresh to read the check results again and so refresh the alert display.

To automatically refresh the display, choose Settings ® Auto-refresh  ® Activate. To set the time interval for automatic refresh, choose Settings ® Auto-refresh  ® Time interval.

¡        Starting database system check

Choose Start to immediately start the database system check.

¡        Viewing standard or history

§         Choose Standard to view all open messages in the selected time period.

§         Choose History to view all messages.

¡        Configuring the database system check

Choose Configure to configure database system check.

¡        Viewing the database operations monitor

Choose DBA Operations to display the DBA logs.

¡        Working with individual alerts

§         To see full details of an alert, double-click on the alert and choose Check log.

§         To delete a selected alert, choose Edit ® Delete.

§         To reset a selected alert that you have fixed, choose Edit ® Reset.

§         To refresh a selected alert, choose Edit ® Refresh.

¡        Configuring the alert display

·         Choose Settings ® View ® Time Period and enter the number of days for which you want to view alerts. For example, if you enter 5 days, you see standard or history alerts for the last five days.

·         Choose Settings ® Auto-delete ® Activate to automatically delete alerts after the specified time interval. To set the time interval, choose Settings ® Auto-delete ® Time Interval.

·         To save your settings, choose Settings ® Save settings.