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