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

Data Dictionary

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Published
July 2021
Language
English (United States)
Last Update
2021-07-27
dita:mapPath
muh1623078990997.ditamap
dita:ditavalPath
muh1623078990997.ditaval
dita:id
B035-1092
lifecycle
previous
Product Category
Teradata Vantageā„¢
Logs Description
Logs that can be either purged manually or using Teradata Viewpoint.
Access Log

(DBC.AccLogTbl)

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

(DBC.EventLog)

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

(DBC.SW_Event_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

(DBC.InDoubtResLog)

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