15.10 - Manually Deleting Old Log Data - Teradata Database

Teradata Database Data Dictionary

Product
Teradata Database
Release Number
15.10
Content Type
Administration
User Guide
Publication ID
B035-1092-151K
Language
English (United States)

You can use the Teradata SQL DELETE statement to purge outdated log data, for example DBC.LogOnOffV log data.

Note: The user executing the SQL statement must have the DELETE privilege on the corresponding view.

For example:

You can purge DBC.LogOnOffV log data based on age. Teradata recommends retaining 90 days of log data and purging directly from the DBC.EventLog table.

DELETE FROM DBC.EventLog
WHERE (DATE-DateFld) > 90;

You can purge information for an account after a cost accounting period has closed.

DELETE FROM DBC.AMPUsageV 
   WHERE Accountname = ’$M619’;
 

For more information on ...

See ...

how to manually purge old logs or copy the data to backup tables

Database Administration.

using the Log Table Clean Up function in Teradata Viewpoint to purge log data

Teradata Viewpoint User Guide.