16.20 - Data Dictionary Logs that Require Manual Purging - Teradata Database - Teradata Vantage NewSQL Engine

Teradata Vantageā„¢ Data Dictionary

Product
Teradata Database
Teradata Vantage NewSQL Engine
Release Number
16.20
Published
March 2019
Language
English (United States)
Last Update
2019-05-03
dita:mapPath
zzu1512081120577.ditamap
dita:ditavalPath
TD_DBS_16_20_Update1.ditaval
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.