16.10 - Options for Flushing the DBQL Cache - Teradata Database

Teradata Database Administration

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

Before Teradata Database writes DBQL data to Data Dictionary tables, it holds the data in cache until either:

  • The cache is full.
  • You end query logging.
  • The number of seconds has elapsed that you define in the DBS Control utility field DBQLFlushRate.
    You can select a rate from 1 to 3,600 seconds. However, Teradata recommends a flush rate of at least 10 minutes (600 seconds), which is the default. Less than 10 minutes can impact performance.
  • You flush the DBQL cache manually.