BUILD - TARA/ABU

Teradata Archive/Recovery Utility Reference

Product
TARA/ABU
Release Number
15.10
Language
English (United States)
Last Update
2018-10-07
dita:id
B035-2412
lifecycle
previous
Product Category
Teradata Tools and Utilities

The BUILD statement generates:

  • Indexes for fallback and non-fallback tables
  • Fallback rows for fallback tables
  • Journal tables by sorting the change images
  • where:

     

    Syntax Element

    Description

    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