Data Dictionary Logs that Require Manual Purging - Teradata Vantage

Teradata® VantageCloud Lake

Deployment
VantageCloud
Edition
Lake
Product
Teradata Vantage
Published
January 2023
ft:locale
en-US
ft:lastEdition
2024-12-11
dita:mapPath
phg1621910019905.ditamap
dita:ditavalPath
pny1626732985837.ditaval
dita:id
phg1621910019905
Logs Description
Logs that can be cleared manually.
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.

The collection rate determines how quickly data accumulates and when to clear the logs.

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 workload management functions.
Logs that can only be cleared manually.
In Doubt transaction Log

(DBC.InDoubtResLog)

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