Logging Period - Advanced SQL Engine - Teradata Database

Resource Usage Macros and Tables

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Published
July 2021
Language
English (United States)
Last Update
2021-07-27
dita:mapPath
dep1592878989156.ditamap
dita:ditavalPath
dep1592878989156.ditaval
dita:id
B035-1099
lifecycle
previous
Product Category
Teradata Vantageā„¢

Resource usage logging means the writing of resource data as rows to one or more of the resource usage database tables. The tables are named DBC.ResUsagexxxx, where xxxx is the name of the resource usage table (for example, SPMA, IPMA, and so on) as listed in Types of Resource Usage Tables.

The shorter the logging period, the more frequently data is logged, and the more disk space is used.

When the system is so busy that the resource usage table logging gets backed up, RSS will automatically double the logging period which effectively summarizes the data by providing values for a time period twice that provided by the previous logging period.

If you see the resource usage logging rates change without user intervention, this means that the database is busy. When no longer busy, the system resumes logging as before.

Events in the event logs related to this doubling of the logging period do not represent fatal errors but are informational to indicate that the automatic operations of the RSS are attempting to maintain data logging.