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.
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.
64 through 1024 KB
Changes Take Effect
After the next Teradata Database restart.
If the LockLogger field is set to FALSE, then the setting for the LockLogSegmentSize field is ineffective.