15.10 - Data Dictionary Logs that Require Manual Purging - Teradata Database

Teradata Database Data Dictionary

Product
Teradata Database
Release Number
15.10
Content Type
Administration
User Guide
Publication ID
B035-1092-151K
Language
English (United States)
 

Logs

Description

Logs that can be either purged manually or using Teradata Viewpoint.

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.

    You can enable ResUsage data collection and set the collection rate using either:

  • The ctl utility SCREEN RSS command
  • Teradata Viewpoint data collectors
  • The collection rate determines how quickly data accumulates and when the logs should be purged.

    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 Teradata Viewpoint workload management functions.

    Logs that can only be purged manually.

    In Doubt transaction Log
    (DBC.InDoubtResLog)

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