Advanced SQL Engine | Utilities | Lock Display (lokdisp) | Teradata Vantage - 17.10 - Lock Display (lokdisp) - 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)
The utility described is not available for as-a-service customers.

The Lock Display utility, lokdisp, provides information about all real-time database locks.

Advanced SQL Engine uses locks for concurrency control, ensuring data involved in a particular transaction remains consistent for the duration of that transaction, while the database remains available to multiple concurrent users and queries. For more information on Advanced SQL Engine locks, see Teradata Vantage™ - SQL Request and Transaction Processing, B035-1142.

Locks are applied automatically as appropriate by Advanced SQL Engine. Optionally, you can specify the lock to be applied to a database object using the SQL LOCKING request modifier. For more information, see Teradata Vantage™ - SQL Data Manipulation Language, B035-1146. Locks are applied to different levels of database objects as required by the particular operation requiring the lock. Locks can be applied with the following granularities:
  • Database
  • Table
  • Partition (row-partition)
  • Range of rows
  • Row (locks rows having a particular rowhash value, which may be more than a single row)
Lock Display can obtain lock information from the following:
  • A specific AMP
  • A group of AMPs
  • All AMPs
For a Advanced SQL Engine 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.

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