17.10 - LockLoggerFlushRate - 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)

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

General

Valid Range

600 through 3600 seconds

Recommended value is 1200 seconds or more.

Default

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.