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

Teradata® Viewpoint User Guide - 24.04

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
Lake
VMware
Product
Teradata Viewpoint
Teradata Workload Management
Release Number
24.04
Published
April 2024
Language
English (United States)
Last Update
2024-04-29
dita:mapPath
xwb1711972215358.ditamap
dita:ditavalPath
tky1501004671670.ditaval
dita:id
xvu1467243446040
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
TDMaps (Teradata Database 16.10 and later)
  • TDMaps.ActionHistoryV
  • TDMaps.LogTbl
  • TDMaps.AnalyzeLogTbl