Delete Old Log Data | Teradata Vantage - Deleting Old Log Data with Teradata Viewpoint - Advanced SQL Engine - Teradata Database

Database Administration

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Published
July 2021
Language
English (United States)
Last Update
2021-07-27
dita:mapPath
upb1600054424724.ditamap
dita:ditavalPath
upb1600054424724.ditaval
dita:id
B035-1093
lifecycle
previous
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.