Delete Old Log Data | Teradata Vantage - Deleting Old Log Data with Teradata Viewpoint - Analytics Database - Teradata Vantage

Database Administration

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
VMware
Product
Analytics Database
Teradata Vantage
Release Number
17.20
Published
June 2022
Language
English (United States)
Last Update
2023-11-03
dita:mapPath
pgf1628096104492.ditamap
dita:ditavalPath
qkf1628213546010.ditaval
dita:id
ujp1472240543947
lifecycle
latest
Product Category
Teradata Vantageā„¢

Configure log data cleanup as follows:

  1. From the Teradata Viewpoint main screen, select Admin > Teradata System.
  2. To configure specific logs for clean up, and specify the cleanup interval:
    1. In the SETUP column, select Log Table Clean Up.
    2. In the TABLES column, select a log table category for cleanup, for example, DBQ Log.
    3. Use default cleanup interval shown unless you have reason to change it.
      Coordinate the interval with your site requirements for storing log history.
    4. Check the Enabled box.
    5. Click the Apply button to activate the cleanup
  3. To specify the time of day that all configured cleanup takes place:
    1. From the SETUP column, select Clean Up Schedule.
    2. Specify a time when the log tables are not active.
      The clean up operation locks the log table and delays logging in the table until log data deletion is complete.
    3. Check the Enabled box.
    4. Click the Apply button to set the cleanup schedule.