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

Teradata® Viewpoint User Guide - 23.04
Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
Lake
VMware
Product
Teradata Viewpoint
Teradata Workload Management
Release Number
23.04
Published
April 2023
Language
English (United States)
Last Update
2023-05-05
dita:mapPath
cxb1678987903668.ditamap
dita:ditavalPath
tky1501004671670.ditaval
dita:id
B035-2206
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 Databasee 14.10 and later)
TDWM
  • DBC.TDWMSummaryLog
  • DBC.TDWMEventLog
  • DBC.TDWMExceptionLog