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.
Note: 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.
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.
REBUILDCI is not allowed if more than one amp is selected
1 of 2 amps have been selected
*** Note: Rebuilding a cylinder’s index could restore cylinder data that was previously deleted or replaced. ***
Rebuild of CI 000100050000018C has been completed
4 PERM DB(s) representing 971 sector(s)
There is a rebuilt CI in memory. You must write or discard the rebuilt [W]CI before changing the scope or quitting from Filer.
WARNING!!: Writing the rebuilt CI will overwrite the existing CI on disk.
Are you sure you want to WRITE this ?? (Y/N)
Rebuilt [W]CI has been written to disk
Filer has exited