17.10 - LockLogSegmentSize [Deprecated] - 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)

Specifies the size of the Lock Logger segment. This field allows you to control the size of the buffer that is used to store lock information.

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 Range

64 KB through 1024 KB

Default

64 KB

Changes Take Effect

After the next database restart.

Usage Notes

If the LockLogger field is set to FALSE, then the setting for the LockLogSegmentSize field is ineffective.