Teradata ARC Locks During a Restore Operation - TARA/ABU

Teradata Archive/Recovery Utility Reference

Product
TARA/ABU
Release Number
16.10
Published
May 2017
Language
English (United States)
Last Update
2018-05-01
dita:mapPath
utr1488824663491.ditamap
dita:ditavalPath
Audience_PDF_include.ditaval
dita:id
B035-2412
lifecycle
previous
Product Category
Teradata Tools and Utilities

A restore operation uses an exclusive HUT lock when data tables are restored.

  • To restore an entire database, Teradata ARC places the exclusive lock at the database level.
  • To restore selected tables, Teradata ARC places the exclusive lock on each table before it starts to restore the table.
  • To restore (or copy) selected partitions of PPI tables, Teradata ARC uses a write lock.
  • To restore selected partitions of PPI tables with GROUP READ LOCK, the entire table locks rather than a part of the table.