Maintaining System Logs | Teradata Vantage - Maintaining System Logs - Advanced SQL Engine - Teradata Database

Data Dictionary

Product
Advanced SQL Engine
Teradata Database
Release Number
17.05
Published
January 2021
Language
English (United States)
Last Update
2021-01-22
dita:mapPath
prb1610499325399.ditamap
dita:ditavalPath
hoy1596145193032.ditaval
dita:id
B035-1092
lifecycle
previous
Product Category
Teradata Vantageā„¢

Some Data Dictionary tables are in the form of logs, which accumulate increasing amounts of data over time. To avoid excess use of perm space, you should periodically delete older information from the log tables using either SQL DELETE requests or the Log Table Cleanup function in Teradata Viewpoint.

Older log data can also be transferred to other storage media if site policy requires long-term log record retention. You can create backup log tables to store log history and periodically copy data from the active logs and archive it to backup tables or long-term table storage. using the BTEQ .EXPORT command, FastExport, or a Backup and Restore (BAR) Software.