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.