Managing Accumulated Log Data - Teradata Database

Teradata Database Administration

Product

Teradata Database

Release Number

15.10

Language

English (United States)

Last Update

2018-10-06

Product Category

Software

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	Description
Logs that can be purged manually or using Teradata Viewpoint. See “Deleting Old Log Data with Teradata Viewpoint” on page 195.
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 must be purged manually purged
In Doubt transaction Log (DBC.InDoubtResLog)	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.