Database Preventive Maintenance | SystemFE Macros | Teradata Vantage - 17.10 - Database Preventive Maintenance - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SystemFE Macros

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Administration
Publication ID
B035-1103-171K
Language
English (United States)

Running Macros Weekly

For preventive maintenance, Teradata recommends 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 the 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.