17.10 - LockLoggerFlushRate - 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 frequency for writing entries to the system table DBC.DBQLXMLLOCKTbl.

the system table DBC.DBQLXMLLOCKTbl stores blocker/blocked transaction and lock information, and is also useful for getting deadlock information.

Field Group


Valid Range

600 through 3600 seconds

Recommended value is 1200 seconds or more.


1200 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.

Usage Notes

You must monitor the system table DBC.DBQLXMLLOCKTbl for performance and data loss and adjust LockLoggerFlushRate accordingly, in increments of 600.

You can access DBC.DBQLXMLLOCKTbl Through the Viewpoint lock viewer portlet or query the system table DBC.DBQLXMLLOCKTbl or the view DBC.QrylockLogXMLV.