16.10 - Methods for Minimizing Log Table Size - Teradata Database

Teradata Database Administration

Teradata Database
Release Number
Release Date
April 2018
Content Type
Publication ID
English (United States)

There are several ways you can minimize the size of your DBQL log tables and therefore avoid running out of disk space in DBC:

  • Add a date column to avoid multiple casting of the time columns.
  • Use MVC on the columns of the copies of DBQL tables.
  • Log only the data you need. For example, if default data in DBQLogTbl is sufficient, do not log WITH SQL or WITH OBJECTS as well.
  • Limit summary logging to just the accounts you want to track.
  • Limit SQL text logging to a specific number of characters.
  • Remember to end logging whenever logging data is no longer needed for a specific user, group of users, account, list of accounts, or applications.