Advanced SQL Engine | Utilities | Show Locks (showlocks) | Teradata Vantage - 17.10 - Show Locks (showlocks) - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - Database Utilities

Advanced SQL Engine
Teradata Database
Release Number
Release Date
July 2021
Content Type
Publication ID
English (United States)
The utility described is not available for as-a-service customers.

The Show Locks utility, showlocks, provides information about Host Utility (HUT) locks placed on databases and tables by the Archive/Recovery (ARC) utility during database operations.

These locks might interfere with application processing and should be released after utility processing is complete. Show Locks also displays information about locks placed during an Advanced SQL Engine system failure.

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.