17.10 - DBQLDefCacheSize - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - Database Utilities

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Configuration
Publication ID
B035-1102-171K
Language
English (United States)

Sets the DBQL cache size and determines whether DBQL uses 64K or 1MB data blocks.

The size of the DBQLParamTbl cache, populated when you begin query logging with the PARAMINFO option, is controlled separately by the DBQLLOBCacheSize DBS Control field.

Field Group

Performance

Valid Range

0 through 16 MB

A value of zero sets the DBQL cache size to 64 K, and causes DBQL to use 64 K data blocks. Any other value causes DBQL to use 1 MB data blocks.

Default

2

Changes Take Effect

After the next database restart.

Usage Notes

  • Increasing the DBQL cache size can reduce the overhead associated with frequent cache flushing. This can be beneficial on extremely busy systems that experience resource contention or exhaustion.
  • Changing DBQLDefCacheSize invalidates the contents of the DBQL caches at the next database restart. Teradata recommends that you flush all DBQL caches prior to restarting the database. Use the following SQL statement:

    FLUSH QUERY LOGGING WITH ALL;

Related Information

For more information on… See…
BEGIN QUERY LOGGING, END QUERY LOGGING, and FLUSH QUERY LOGGING statements Teradata Vantage™ - SQL Data Definition Language Syntax and Examples, B035-1144.
tracking processing behavior with the DBQL Teradata Vantage™ - Database Administration, B035-1093.
DBQLLOBCacheSize field DBQLLOBCacheSize