Managing Accumulated Log Data - Teradata Database

Teradata Database Administration

Teradata Database
Release Number
English (United States)
Last Update
Product Category

About Database Logs

Teradata Database contains a number of log tables that accumulate data, either automatically or after certain features are enabled. Because log data grows over time, you must periodically purge older information to avoid using up permanent space.




Logs that can be purged manually or using Teradata Viewpoint. See “Deleting Old Log Data with Teradata Viewpoint” on page 195.

Access Log

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

    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

    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 must be purged manually purged

    In Doubt transaction Log

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

    Note: Depending on site requirements, you may need to retain older data long after it should be removed from an active log. If so, you can create backup log tables to store log history and periodically copy data from the active logs to the backup tables. You can also archive copies of the backup tables on tape for long-term reference.

    Reference Information


    Information on...

    Is available in...

    configuration and use of DBQL

    Chapter 15: “Tracking Query Behavior with Database Query Logging: Operational DBAs”

    using the ctl utility SCREEN RSS command to set up ResUsage logging and log intervals

    the SCREENRSS command in Chapter 8: “Control GDO Editor (ctl), in Utilities.

    setting up Teradata Viewpoint data collectors

    “Enable the Data Collectors” in “Configure Viewpoint to Monitor a Teradata Database,” in Teradata Viewpoint Configuration Guide.