Alerts: Alert Configuration (DB2 UDB for UNIX and Windows) 

DB2 database system monitoring has preconfigured check categories and parameters.

Only experienced users should make changes to the system check configuration.

The initial screen of the database-specific configuration provides you with an overview of all the configuration entries.

You can access alert configuration by calling the DBA Cockpit and choosing Alerts ® Alert Configuration in the navigation frame of the DBA Cockpit. The Alert Configuration Overview screen appears.

On this screen, you can display details, sort entries, and make selections using the list boxes.  In addition, you can activate or deactivate an entry by selecting the corresponding cell in the Active column.

If you deactivate an entry, there is no further notification of corresponding alerts.

If you want to configure additional parameters, you can double-click a cell in the table or select a line and choose  Details. The Alerts: Display Configuration screen appears providing the following information:

·        Threshold

This tabstrip is divided into three group boxes showing the respective status:

¡        Normal State

¡        Warning

Limited operation, for example, with reduced performance

¡        Error

Normal operation is endangered if the error is not corrected

In each of these group boxes you can configure three values according to which the system is monitored:

¡        Relational operators

You can specify how the defined comparison value should be compared with the current given value. In addition to the relational operators, you may enter whether a value should lie inside of or outside of a range of values. A full colon ( : ) must separate the two values. You may also specify whether or not discrete values are within a set of explicit values. Semicolons ( ; ) must separate such values.

¡        Comparison value

You can specify a value, a list of values or a value range depending on the operator. This value will later be compared with the current measured value.

¡        Unit of measurement of the comparison value

You can specify the unit of measurement of the comparison value. This is important for time values, which are normally calculated internally in seconds, to be correctly converted before comparison.

Additionally, you can specify whether or not you want to receive an automatic e-mail notification in the event of an alert.

Values do not need to be entered for every operation status. However, you must make sure that the sum of comparison values must cover every possible value. If this is not the case, a special alert is triggered with the following message:

There is no configuration entry for the logged value

·        General (RZ21)

This tabstrip displays the scheduling data from the basic alert monitor configuration. The values are displayed here for completeness. It is not possible to make changes in this transaction. You can make changes using the general maintenance function (transaction RZ21) in the alert monitor.

·        Administration

This tabstrip displays the user that made the last changes and whether this entry is currently active.

After you have made your changes, save them. Changes take effect immediately.