Copy operations apply exclusive utility (HUT) locks on the object to be copied. Therefore, if a full database is copied from a complete database archive, Teradata ARC locks the entire database. Similarly, if a single table is copied from a table-level archive, Teradata ARC locks that table (but only that table). To copy selected partitions, Teradata ARC applies a HUT write lock.
When an SQL-UDF is copied, the corresponding DBC.DBASE row is locked with a write hash lock. This prevents the user from doing any DDL on that database for the duration of the copy operation.