16.10 - REBUILDCI - Teradata Database

Teradata Database Support Utilities

prodname
Teradata Database
vrm_release
16.10
created_date
June 2017
category
Configuration
featnum
B035-1180-161K

Purpose

The REBUILDCI command reconstructs a cylinder index from the sectors in the data area of the cylinder. This command works for both regular cylinder indexes (CIs) and WAL cylinder indexes (WCIs). REBUILDCI can be used when one or both copies of a CI or WCI have been corrupted.

This command can be used only when Teradata Database is not running on the affected AMP.

Freed sectors that contain obsolete data from previously removed tables and rows can be restored to the index by the REBUILDCI command. Be aware of this possibility, and inspect rebuilt cylinders before writing them to disk.

Syntax



Usage Notes

The REBUILDCI command can be used only when Filer scope is set to a single vproc.

The index for the specified cylinder is rebuilt in memory, but is not committed to disk until the WRITE command is issued.

A rebuilt index in memory must be written to disk or discarded before changing the scope or quitting Filer.

Running this command switches Filer to the REBUILDCI mode, indicated by the REBUILDCI command prompt. In this mode, the INFO, REPAIRSECTS, and DISCARD commands can be used to inspect and modify the rebuilt index before it is written to disk.

Example: Using the Filer REBUILDCI command

Filer ==>
rebuildci 000100050000018C

REBUILDCI is not allowed if more than one amp is selected

Filer ==>
scope 1

1 of 2 amps have been selected


Filer ==>
rebuildci 000100050000018C

*** Note: Rebuilding a cylinder’s index could restore cylinder data that was previously deleted or replaced. ***

Rebuild of CI 000100050000018C has been completed

Found
        4 PERM     DB(s) representing   971 sector(s)


REBUILDCI ==>
quit

There is a rebuilt CI in memory.  You must write or discard the rebuilt [W]CI before changing the scope or quitting from Filer.

REBUILDCI ==>
write

WARNING!!: Writing the rebuilt CI will overwrite the existing CI on disk.
           Are you sure you want to WRITE this ?? (Y/N)
y

Rebuilt [W]CI has been written to disk

FILER ==>
quit

Filer has exited