CLUSTER Keyword - Teradata Tools and Utilities

Teradata® Archive/Recovery Utility Reference

Product
Teradata Tools and Utilities
Release Number
16.20
Published
March 2019
Language
English (United States)
Last Update
2019-06-05
dita:mapPath
fac1527114221922.ditamap
dita:ditavalPath
Audience_PDF_include.ditaval
dita:id
B035-2412
Product Category
Teradata Tools and Utilities

The following rules apply to this option:

  • The option is allowed only when restoring data tables.
  • Restore the dictionary before restoring the cluster.
  • Restore a cluster only from a cluster archive.
  • Perform a build operation on a non-fallback table with unique secondary indexes before updating it using Teradata SQL.
  • The building of fallback data during cluster restores depends on the Teradata Database software release.

Teradata ARC builds all indexes except unique indexes. Do not update a fallback table with unique indexes using Teradata SQL after a cluster restore until a build is performed.

If any AMPs in the list of clusters are offline, restore any non-fallback table to those AMPs when they are brought back online. A specific AMP restore can be from a specific AMP or cluster archive.

Teradata ARC releases HUT locks at the cluster level.