16.10 - Finding and Resolving Lock Contentions - Teradata Database

Teradata Database Administration

Product
Teradata Database
Release Number
16.10
Release Date
April 2018
Content Type
Administration
Publication ID
B035-1093-161K
Language
English (United States)
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 - Syntax and Examples.
  • For more information on the Lock Viewer portlet, see Teradata Viewpoint User Guide.