15.00 - LockLogger Delay Filter - Teradata Database

Teradata Database Utilities

Product
Teradata Database
Release Number
15.00
Content Type
Configuration
Publication ID
B035-1102-015K
Language
English (United States)
Last Update
2018-09-25

LockLogger Delay Filter

Purpose  

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

Note: 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 Database Administration and the BEGIN QUERY LOGGING statement in SQL Data Definition Language.
  • For more information on the Lock Viewer portlet, see Teradata Viewpoint User Guide.
  • Field Group

    General

    Valid Settings

     

    Setting

    Description

    TRUE

    Enable filtering

    FALSE

    Disable filtering

    Default

    FALSE.

    Note: 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.

    Related Topics

  • “LockLogger Delay Filter” on page 360
  • “LockLogger Delay Filter Time” on page 361
  • “LockLogSegmentSize” on page 363