16.10 - Deleting Old Log Data with Teradata Viewpoint - Teradata Database

Teradata Database Administration

Teradata Database
Release Number
Release Date
April 2018
Content Type
Publication ID
English (United States)

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.