Usage Notes - 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

Teradata ARC processes databases, tables, and stored procedures in alphabetical order. Database DBC does not contain non-fallback tables and cannot be restored by clusters. Therefore, Teradata ARC does not try to build indexes or fallback data for any table in database DBC.

A build operation creates unique and non-unique secondary indexes for a specified table. The build operation also generates the fallback copy of fallback tables if DATA TABLES keywords are specified.

Typically, this statement is used after one of the following:

  • Specific AMP restore of non-fallback tables
  • Cluster archive restoring
  • Series of all-AMPs restores that specified the NO BUILD option (usually a restore to a changed hardware configuration)
To speed the recovery of all AMPs, specify the NO BUILD option of the RESTORE statement to prevent non-fallback tables from being built after the restore is complete.

If an AMP is offline during a build operation, all unique secondary indexes of non-fallback tables are left invalidated. As a result, requests may run more slowly when secondary indexes are used for search and selection. Insert and update operations cannot occur.

When a database or table copies or restores from an older version source system with a different configuration, it affects the time and space required to restore data to the destination system. The data must be redistributed among the new set of AMPs. The system uses a different algorithm to copy and restore when the number of AMPs is different between the source and destination systems. This new algorithm is usually faster when the configurations are different. The old algorithm may be faster in some restricted situations.