16.20 - Manually Deleting Old Log Data - Teradata Database - Teradata Vantage NewSQL Engine

Teradata Vantage™ Data Dictionary

Product
Teradata Database
Teradata Vantage NewSQL Engine
Release Number
16.20
Published
March 2019
Language
English (United States)
Last Update
2019-05-03
dita:mapPath
zzu1512081120577.ditamap
dita:ditavalPath
TD_DBS_16_20_Update1.ditaval

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

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’;