Monthly Maintenance Process - Teradata Database

Teradata Database Administration

Product
Teradata Database
Release Number
15.10
Language
English (United States)
Last Update
2018-10-06
Product Category
Software

The monthly maintenance process consists of one step that executes the purge macro SYS_MGMT.PRGDBQLHSTTBLS.

Retaining data for thirteen months is recommended to facilitate this year/last year comparisons. Thus, once a month the monthly maintenance script should be run to remove the 14th oldest month of data from SYS_MGMT DBQL History tables.