Purging | Resource Usage Macros/Tables | Teradata Vantage - 17.20 - Purging Data - Analytics Database - Teradata Database

Teradata Vantageā„¢ - Resource Usage Macros and Tables - 17.20

Product
Analytics Database
Teradata Database
Release Number
17.20
Published
June 2022
Language
English (United States)
Last Update
2022-10-17
dita:mapPath
efj1628112349534.ditamap
dita:ditavalPath
qkf1628213546010.ditaval

The RSS does not automatically delete data from the resource usage tables. You need to purge data you no longer need on a regular basis.

You can directly remove old resource usage data by submitting SQL statements. For example, use the following SQL statement to remove data more than seven days old from the ResUsageSpma table:

   DELETE FROM ResUsageSpma WHERE TheDate < CURRENT_DATE - 7;

For more information about the DELETE syntax, see Teradata Vantageā„¢ - SQL Data Manipulation Language, B035-1146.