16.10 - RESTART REBUILD - Teradata Database

Teradata Database Utilities

Product
Teradata Database
Release Number
16.10
Published
June 2017
Language
English (United States)
Last Update
2018-04-26
dita:mapPath
zll1480972831047.ditamap
dita:ditavalPath
changebar_rev_16_10_exclude_audience_ie.ditaval

Purpose

Restarts an all-table rebuild operation (REBUILD command with the ALL TABLES options specified).

If a Teradata Database failure occurs while a Table Rebuild is running for all tables, this command restarts the rebuild process, bypassing databases and tables already rebuilt, and continuing from the table that was being rebuilt when the system failed.

Syntax



nnnn
The vproc number of the AMP which was previously running the ALL TABLES rebuild.

Usage Notes

The RESTART REBUILD command restarts an all-table rebuild that was terminated by a system restart or failure. After RESTART REBUILD is executed, no intervention is required.

Table Rebuild automatically determines where the rebuild terminated and restarts at the appropriate place. Table Rebuild determines where to restart by using the spool files that contain the database names and table names to be rebuilt (in order by database ID and by table ID within the database). Before each subtable (primary or fallback) is rebuilt, Table Rebuild writes a restart record to the current DBC table SysRcvStatJournal.

When you start a RESTART REBUILD, the program reads the restart record and positions itself in the spool file accordingly. After completion of the Table Rebuild, the restart row is deleted from the journal table.