Repair Data Corruption | Teradata Vantage - Repairing Data Corruption - Analytics Database - Teradata Vantage

Database Administration

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
VMware
Product
Analytics Database
Teradata Vantage
Release Number
17.20
Published
June 2022
Language
English (United States)
Last Update
2023-11-03
dita:mapPath
pgf1628096104492.ditamap
dita:ditavalPath
qkf1628213546010.ditaval
dita:id
ujp1472240543947
lifecycle
latest
Product Category
Teradata Vantageā„¢

Table Rebuild is a utility that repairs data corruption. It does so by rebuilding tables on a specific AMP vproc based on data located on the other AMP vprocs in the fallback cluster.

Table Rebuild can rebuild data in the following subsets:

  • The primary or fallback portion of a table
  • An entire table (both primary and fallback portions)
  • All tables in a database
  • All tables that reside on an AMP vproc

Table Rebuild performs differently based on the type of table (for example, fallback or not).

Type of Table Action
Fallback Tables Delete the table header (one row table which defines a user data table)

Delete specified portion of the table being rebuilt

Rebuild the table header

Rebuild the specified portion of the table

Non-fallback Tables Delete the table header.

Rebuild the table header.

Permanent Journal Tables Delete data for the table being rebuilt.

Rebuild the table header.

Locks the table pending rebuild.

You must restore non-fallback data.
You can start REBUILD when the failed AMP has been fixed and brought back to the OFFLINE state.