RESTART REBUILD - Analytics Database - Teradata Vantage

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

If a 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

RESTART REBUILD ON AMP nnnn ;

RESTART REBUILD ON AMP nnnn [, LOGRATE n];

Syntax Elements

nnnn

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

LOGRATE n

Provides progress information while rebuilding. Rebuild progress information is reported every n minutes. n is an integer from 1 to 10.

The output is similar to this:

P 05:04:32 Progress info status: 1.20% 667 MB/55522 MB 11.1 MB/s 00:01:11 ETA 01:22:09

The letter P indicates the message code for progress information. It is followed by the current system time, percentage of rebuild done, data size done so far/total size, rate at which rebuild is progressing, elapsed time, and estimated turnaround time.

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.