15.11 - HUT Locks in Copy and Restore Operations - Data Stream Architecture

Teradata Data Stream Architecture (DSA) User Guide

prodname
Data Stream Architecture
vrm_release
15.11
created_date
December 2016
category
User Guide
featnum
B035-3150-026K

Restore and copy operations apply exclusive utility (HUT) locks on all objects to be restored or copied.

SQL User-Defined Function

When you copy an 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.