16.20 - Teradata Database Preventive Maintenance - Teradata Vantage NewSQL Engine

Teradata Vantage™ SystemFE Macros

Teradata Database
Teradata Vantage NewSQL Engine
March 2019

Running Macros Weekly

For preventive maintenance, Teradata recommends that you run the following macros in the following order at least on a weekly basis:

  • EventCount
  • AllRestarts
  • DiskEvents
  • MiniCylPacks
  • PackDisk
  • ListEvent

Generating the Preventive Maintenance Report

Executing the macros in the above order provides a Preventive Maintenance Report listing summary information followed by detailed information for the week. Used in this manner, the macros should be executed with ‘Date-7’ as the FromDate and ‘Date-1’ as the ToDate. For example, the following BTEQ statement provides a report listing all the events that occurred on Teradata Database during the specified time period (that is, the last 7 days excluding the date of today) with the number of occurrences:

Exec EventCount (Date-7, Date-1);

If you have access to a client user ID or access to the system console, you can write a BTEQ script in the above syntax. Then, you can run the script on a weekly basis without changing the date parameter.