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

Teradata Vantage™ - Resource Usage Macros and Tables

prodname
Advanced SQL Engine
Teradata Database
vrm_release
17.00
17.05
created_date
June 2020
category
Administration
User Guide
featnum
B035-1099-170K

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 “Statement Syntax” in Teradata Vantage™ - SQL Data Manipulation Language, B035-1146.