15.00 - Chapter 16 Lock Display (lokdisp) - 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

The Lock Display utility, lokdisp, provides a snapshot capture of all real-time database locks.

The database software uses locks for concurrency control. lokdisp displays locks used for concurrency. A lock can be applied to a database object based on the following lock granularity:

  • Database
  • Table
  • Rowhash Range
  • Rowhash
  • Optionally, you can specify the lock to be applied to a database object using the SQL Locking Modifier.

    lokdisp can obtain lock information from the following:

  • A specific AMP
  • A group of AMPs
  • All AMPs
  • Note: For a Teradata Database system with many AMPs and a heavy load, be careful when selecting the number of AMPs from which to obtain information. The fewer the AMPs selected, the lower the volume of lock information generated, and the more manageable the output. Teradata recommends obtaining information from all AMPs only when the lock information for a specific transaction is needed.

    For detailed examples of returned data, see “DB” on page 673 and “TABLE” on page 683.

    Lock information can also be monitored and displayed using the Lock Viewer portlet in Teradata Viewpoint. For more information, see Teradata Viewpoint User Guide.

    Scenarios Runs From

  • Database Window or comparable interface to the Teradata Database console subsystem, such as cnsterm
  • Linux command line
  • Teradata Viewpoint Remote Console portlet
  • For general information on starting the utilities from different interfaces, see Appendix B: “Starting the Utilities” For information on Viewpoint, see Teradata Viewpoint User Guide.