15.00 - Chapter 22 Show Locks (showlocks) - Teradata Database

Teradata Database Utilities

Teradata Database
Release Number
Content Type
Publication ID
English (United States)
Last Update

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 a Teradata Database 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.

Scenarios Runs From

  • Database Window or comparable interface to the Teradata Database console subsystem, such as cnsterm
  • Teradata Viewpoint Remote Console portlet
  • Host Utility Console
  • 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.