Cleanup Tables | Teradata Viewpoint - Cleanup Tables - Teradata Viewpoint - Teradata Workload Management

Teradata® Viewpoint User Guide
Product
Teradata Viewpoint
Teradata Workload Management
Release Number
16.50
16.20
Published
July 2021
Language
English (United States)
Last Update
2021-07-27
dita:mapPath
yqb1520516846011.ditamap
dita:ditavalPath
yqb1520516846011.ditaval
dita:id
B035-2206
lifecycle
previous
Product Category
Analytical Ecosystem
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