15.00 - Chapter 22 Show Locks (showlocks) - 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 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.