17.10 - DBQLLOBCacheSize - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - Database Utilities

Advanced SQL Engine
Teradata Database
Release Number
Release Date
July 2021
Content Type
Publication ID
English (United States)

Determines the amount of cache (in megabytes) allocated for DBQL Data Dictionary tables that have LOB columns. This field also determines the size of the express message used to flush this cache.

Teradata recommends leaving this field set to the default value.

Field Group


Valid Range

2 through 16 MB


2 MB

Changes Take Effect

After the next database restart.

Usage Notes

Increasing the cache size allows larger requests to be captured by DBQL, and reduces the number of cache flushes. However, it will increase the express request message size when flushing the cache.

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.