Cleanup Tables

Teradata® Viewpoint User Guide

brand
Analytical Ecosystem
prodname
Teradata Viewpoint
Teradata Workload Management
vrm_release
16.20
category
User Guide
featnum
B035-2206-107K
The following cleanup processes delete the associated system log tables.
Cleanup Process Name System Log Table Name
Access Log
  • DBC.AccLogTbl
DBQ Log
  • DBC.DBQLExplainTbl
  • DBC.DBQLObjTbl
  • DBC.DBQLogTbl
  • DBC.DBQLParamTbl (Teradata Database 15.0 and later)
  • DBC.DBQLStepTbl
  • DBC.DBQLSqlTbl
  • DBC.DBQLSummaryTbl
  • DBC.DBQLUtilityTbl (Teradata Database 15.0 and later)
  • DBC.DBQLXMLTbl
Event Log
  • DBC.EventLog
Resource Usage
  • DBC.ResUsageSpma
  • DBC.ResUsageSvpr
  • DBC.ResUsageShst
  • DBC.ResUsageIpma
  • DBC.ResUsageIvpr
  • DBC.ResUsageScpu
  • DBC.ResUsageSldv
  • DBC.ResUsageSawt
  • DBC.ResUsageSps
  • DBC.ResUsageSpdsk
  • DBC.ResUsageSvdsk
SW Event Log
  • DBC.SW_Event_Log
TDStats
  • TDStats.AutomateHistoryTbl (Teradata Database 14.10 and later)
  • TDStats.AnalyzeHistoryTbl (Teradata Database 14.10 and later)
  • TDStats.CommandsHistoryTbl (Teradata Database 14.10 and later)
TDWM
  • DBC.TDWMSummaryLog
  • DBC.TDWMEventLog
  • DBC.TDWMExceptionLog