HUT Locks in Copy and Restore Operations - BAR - Data Stream Architecture - Copy and restore operations apply exclusive host utility (HUT) locks on all objects to be copied or restored. Learn more here.

Teradata® DSA User Guide
Product
BAR
Data Stream Architecture
Release Number
16.20
Published
November 2019
Language
English (United States)
Last Update
2019-11-27
dita:mapPath
xfr1514490991957.ditamap
dita:ditavalPath
3150_DSA_UG_1650-working-RR-new.ditaval
dita:id
B035-3150
lifecycle
previous
Product Category
Software
Teradata Tools and Utilities

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.