Specifies a threshold time delay value (in seconds). Lock requests that are blocked for less than this amount of time are not logged. This prevents the log table from being filled with data for insignificantly blocked locks.
- For more information on DBQL, see Database Administration and the BEGIN QUERY LOGGING statement in SQL Data Definition Language - Syntax and Examples.
- For more information on the Lock Viewer portlet, see Teradata Viewpoint User Guide.
0 through 1,000,000 seconds
|IF you set LockLogger Delay Filter Time to…||THEN blocked lock requests with a delay of…|
|0 seconds||0 seconds would not be logged.|
|10 seconds||10 seconds or less would not be logged.|
|1,000,000 seconds||1,000,000 seconds or less would not be logged.|
Changes Take Effect
After the DBS Control Record has been written.
The LockLogger Delay Filter Time field has a dependency on the Lock Logger Delay field and the LockLogger field.
|IF the LockLogger field is…||THEN LockLogger Delay Filter Time field is…|
|FALSE, and the LockLogger Delay Filter field is TRUE||ineffective.|
|TRUE, and the LockLogger Delay Filter field is FALSE||ineffective.|
|TRUE, and the LockLogger Delay Filter field is TRUE||effective.|