15.10 - Analyzing Preventive Maintenance Reports - Teradata Database

Teradata Database SystemFE Macros

Teradata Database

Analyzing Preventive Maintenance Reports

In general, SystemFE macros are made available as a method for producing quick reports relevant to system messages stored in the DBC.SW_Event_Log. Informational, Warning, and Critical system messages are stored in the DBC.SW_Event_Log until they are manually deleted. Although not the only or definitive resource, this repository is good to consult for determining the relative health of the Teradata Database platform.

Since system messages are stored in the DBC.SW_Event_Log until they are deleted manually, the System Administrator should develop a plan for deleting old messages from the Event_Log to keep it from growing to an unusually large size. Event_Log messages older than 90 days often are not useful. Proactive health checks should be performed every 30 days (not to exceed 90 days). On the reactive problem discovery side, 90-day-old messages rarely are helpful in determining current problems.

When the Preventive Maintenance Report is generated, the data must be analyzed. The order in which the macros were run is important. The analysis can be divided into three steps, each step encompassing more detail than the last. The sections below describe the steps.