HUT Locks in Copy and Restore | Teradata DSA - 17.20 - HUT Locks in Copy and Restore Operations - BAR - Data Stream Architecture

Teradata® DSA User Guide

Data Stream Architecture
Release Number
Release Date
October 2021
Content Type
User Guide
Publication ID
English (United States)

Copy and restore operations apply exclusive host utility (HUT) locks on all objects to be copied or restored.

SQL User-Defined Function

When you copy a SQL User-Defined Function, the corresponding DBC.DBASE row is locked with a write hash lock. This prevents the user from using any Data Definition Language on that database for the dictionary phase of the copy operation.