LockLogger Delay Filter - Advanced SQL Engine - Teradata Database

Database Utilities

Product
Advanced SQL Engine
Teradata Database
Release Number
17.00
Published
June 2020
Language
English (United States)
Last Update
2020-06-15
dita:mapPath
boh1556732696163.ditamap
dita:ditavalPath
lze1555437562152.ditaval
dita:id
B035-1102
lifecycle
previous
Product Category
Teradata Vantage™

Purpose

Enables or disables log filtering of blocked lock requests based on delay time.

The command-line Lock Logger utility (dumplocklog) and related DBS Control settings are deprecated, but remain available for compatibility with prior releases. Database locks should be logged using the Database Query Log (DBQL). This lock information can be accessed by means of the Teradata Viewpoint Lock Viewer portlet, or by querying the DBC.QrylockLogXMLV view.
  • For more information on DBQL, see Teradata Vantage™ - Database Administration, B035-1093 and the BEGIN QUERY LOGGING statement in Teradata Vantage™ - SQL Data Definition Language Syntax and Examples, B035-1144.
  • For more information on the Lock Viewer portlet, see Teradata® Viewpoint User Guide, B035-2206.

Field Group

General

Valid Settings

Setting Description
TRUE Enable filtering
FALSE Disable filtering

Default

FALSE.

If the LockLogger field is set to FALSE, then the settings for the LockLogger Delay Filter field and the LockLogger Delay Filter Time field are ineffective.

Changes Take Effect

After the DBS Control Record has been written.