15.00 - DBQLFlushRate - Teradata Database

Teradata Database Utilities

Product
Teradata Database
Release Number
15.00
Content Type
Configuration
Publication ID
B035-1102-015K
Language
English (United States)
Last Update
2018-09-25

DBQLFlushRate

Purpose  

Defines the interval in seconds between flushings of the DBQL caches to the DBQL dictionary tables.

Field Group

General

Valid Range

1 through 3600 seconds

Note: Teradata does not recommend values less than 600 seconds, and DBS Control issues a warning if you set the value below 600 seconds.

Default

600 seconds

Changes Take Effect

After the DBS Control Record has been written. However, DBQL will not become aware of the new setting until the current timer expires (or 10 minutes passes). Therefore, the change could take up to 10 minutes to become effective.

Usage Notes  

If an END QUERY LOGGING statement is issued, all the caches (except the DBQLSummary cache, which is flushed at the selected Flush Rate) are flushed as part of the END QUERY LOGGING statement.

If a FLUSH QUERY LOGGING statement is issued, the caches requested are flushed. To flush all the caches, use the All option in FLUSH QUERY LOGGING.

Example  

Assume that the DBQLFlushRate is 300 seconds. This means that the cache entries are written to the DBQL dictionary tables at least every 5 minutes. If a cache is filled up after 3 minutes, entries are written at 3 minutes and then again at the 5-minute interval.

Related Topics

 

For more information on…

See…

BEGIN QUERY LOGGING, END QUERY LOGGING, and FLUSH QUERY LOGGING statements

SQL Data Definition Language.

tracking processing behavior with the DBQL

Database Administration.