Manually Deleting Old Log Data - Teradata Vantage

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

For example:

You can clear 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 clear information for an account after a cost accounting period has closed.

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