15.00 - Conditions That Support Reading or Repairing Data from Fallback - Teradata Database

Teradata Database Design

prodname
Teradata Database
vrm_release
15.00
category
User Guide
featnum
B035-1094-015K

Conditions That Support Reading or Repairing Data from Fallback

Reading or repairing data from fallback is limited to the following table, subtable, and data block types:

  • Hashed tables.
  • Primary hash index, join index, and USI subtable data blocks.
  • Reading or repairing data from fallback cannot be done for the following table types:

  • Unhashed tables.
  • BLOB, CLOB, or XML subtables.
  • NUSI subtables, whether their parent table is defined with fallback or not.
  • Reading or repairing data from fallback can only be used when:

  • All AMPs in the fallback cluster are up.
  • Requests do not try to modify the data in the bad data block.