Syntax - 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


where:

DATA TABLESJOURNAL TABLESNO FALLBACK TABLES or NO FALLBACK TABLE
Keywords specifying the type of table to build
The default is NO FALLBACK TABLE.
Specify DATA TABLES when building fallback, nonfallback, or both types of tables from all AMPs. This option normally follows the restore of a cluster archive.
Specify NO FALLBACK TABLE only when building indexes for non-fallback tables.
(dbname)
Name of a database
ALL
Keyword to indicate the operation affects the named database and its descendants
(dbname.tablename)
Name of a non-fallback table for which indexes are built
EXCLUDE
Keyword to prevent indexes from being built in specified databases
(dbname)
Name of database excluded from the build operation
ALL
Keyword to indicate the operation affects the named database and its descendants
(dbname1) TO (dbname2)
List of alphabetically client sorted databases excluded from the build operation
The delimiting database names need not identify actual databases.
Database DBC is not included as part of a range.
RELEASE LOCK
Keywords to release utility locks on the specified objects when the build operation completes successfully
ABORT
Keyword to abort the build operation if an AMP is offline and if the object being built is either a nonfallback table or is a database that contains a nonfallback table
SKIP JOIN INDEX
Skip the build of join and hash indexes