Query Data Storage and Protection - Teradata Database

Teradata Database Administration

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

Because of its nature, there is no recovery mechanism for the cache in which DBQL row values are collected. Should a Teradata Database restart occur, any rows in cache that have not been sent to the AMPs are lost. However, query logging is not aborted as a result of a restart; DBQL uses the contents of DBQLRuleTbl to continue logging.

For information on flushing the DBQL cache information to the logs, see “Options for Flushing the DBQL Cache” on page 372 and “Flushing the DBQL Cache Manually” on page 372.