Alerts: Alert Message Log (DB2 UDB for UNIX and Windows) 

You can access an overview of the results of system monitoring by calling the DBA Cockpit and choosing Alerts ® Alert Message Log in the navigation frame of the DBA cockpit. The Alerts: Alert Message Log screen appears.

Only the most important data is displayed in the overview. The results are displayed as notes, warnings or errors and are ordered by log date as default.

You can use the list boxes in the Current Selection group box to limit the display to specific error levels, check categories, or partitions (only for multi-partition database systems). The Objects and Attributes fields enable restrictions to single attributes. Additionally, you can specify a time period for which the messages are displayed. The message of the last seven days are displayed as default.

You can display more detailed information by selecting a line and choosing  Details.  The Alerts: Alert Message Details screen appears. If you have selected more than one line, you can use the page buttons on the screen to navigate between them.

The detail screen is divided into the following group boxes:

·        Alert Message Details

Complete description of the attribute, as displayed in the alert monitor tree

·        Logged Data

Information on the message, for example, type of error, reported value, and date and time when it occurred

·        Description

Description of the type of error and which value or parameter is being monitored

Deleting Alert Messages

You can delete messages from any given time period by selecting a line and choosing Delete. If you choose Delete without selecting a line, a dialog box appears. In the Date field, you can specify the date from which you want all messages to be deleted. You can also enter the category or partition as selection criteria.

It is also possible to delete a selected alert message in the detail screen.

To ensure that the log table does not get too large, automatic clean-up programs run and delete entries older than thirty days.

Displaying Data in the Alert Monitor Tree

...

       1.      Call transaction RZ20.

The Alert Monitor Set screen appears.

       2.      Expand SAP CCMS Monitor Templates and double-click Database.

       3.      Expand DB2 Universal Database for NT/UNIX.

       4.      You can display information on:

¡        Space management

¡        Performance

¡        Backup/restore

¡        R/3 consistency

¡        Health

The checked parameters are displayed in the following colors depending on the type of message:

 

If a check resulted in a warning or error, a short text is additionally displayed next to the parameter in the Open alerts view.