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

Product
BAR
Data Stream Architecture
Release Number
17.20
Published
November 2022
Last Update
2022-11-14
Content Type
User Guide
Publication ID
B035-3150-101K
Language
English (United States)
Last Update
2022-11-14

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.