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

Advanced SQL Engine
Teradata Database
Release Number
June 2020
English (United States)
Last Update

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.