17.10 - Data Dictionary Logs that Require Manual Purging - Advanced SQL Engine - Teradata Database

Teradata Vantageā„¢ - Data Dictionary

Advanced SQL Engine
Teradata Database
Release Number
Release Date
July 2021
Content Type
Programming Reference
Publication ID
English (United States)
Logs Description
Logs that can be either purged manually or using Teradata Viewpoint.
Access Log


Data collected as defined in a BEGIN LOGGING statement, for each privilege check of an attempted user access of a database object.
DBQ Logs:
  • DBC.DBQLSummaryTbl
  • DBC.DBQLStepTbl
  • DBC.DBQLogTbl
  • DBC.DBQLObjTbl
  • DBC.DBQLExplainTbl
  • DBC.DBQLSqlTbl
Data collected during database query logging (DBQL), if DBQL is enabled.
Event Log


Data collected automatically by the system for each user logon event.
ResUsage Logs:
  • DBC.ResUsageSpma
  • DBC.ResUsageSvpr
  • DBC.ResUsageShst
  • DBC.ResUsageIpma
  • DBC.ResUsageIvpr
  • DBC.ResUsageScpu
  • DBC.ResUsageSldv
  • DBC.ResUsageSawt
  • DBC.ResUsageSps
  • DBC.ResUsageSpdsk
  • DBC.ResUsageSvdsk
ResUsage tables collect data on system resource usage.

You can enable ResUsage data collection and set the collection rate using either:

  • The ctl utility SCREEN RSS command
  • Teradata Viewpoint data collectors

The collection rate determines how quickly data accumulates and when the logs should be purged.

SWEvent Log


The system automatically inserts rows in response to software errors and system events, for use by Teradata Customer Service.
TDWM Logs:
  • DBC.TDWMSummaryLog
  • DBC.TDWMEventLog
  • DBC.TDWMExceptionLog
Logs for Teradata Viewpoint workload management functions.
Logs that can only be purged manually.
In Doubt transaction Log


Contains a row for each transaction where completion was in doubt.