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

Teradata Vantage™ - Database Administration

Product
Advanced SQL Engine
Teradata Database
Release Number
17.00
17.05
Published
June 2020
Language
English (United States)
Last Update
2021-01-22
dita:mapPath
rgu1556127906220.ditamap
dita:ditavalPath
lze1555437562152.ditaval

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.