You can use the Teradata SQL DELETE statement to purge outdated log data, for example DBC.LogOnOffV log data.
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’;