15.00 - REPAIRSECTS - Teradata Database

Teradata Database Support Utilities

prodname
Teradata Database
vrm_release
15.00
category
Configuration
featnum
B035-1180-015K

REPAIRSECTS

Purpose  

The REPAIRSECTS command helps to resolve overlapping DBs on rebuilt CIs, and overlapping WDBs on rebuilt WCIs.

Syntax  

Usage Notes  

This command can be used only from the REBUILDCI command prompt.

Example  

Filer ==> 
info
Command has been sent to Slave tasks.
vproc  0 (0000)  response
REBUILDCI has rebuilt CI 000100050000018C on this vproc.  The rebuilt CI has not been 
written to disk.
The DBs listed below have overlapping rowids: 
Start Sectors      TableID             FirstrowID           Lastrowkey
 02DE    0045   0000 0416 0404  *0000 97F6 D26A 0000 0001  *0000 9BFB F9E2
 0323    0045   0000 0416 0404  *0000 9BFA 3405 0000 0001  *0000 9FFD BFFC

The DBs listed below have overlapping sectors:
Start Sectors      TableID             FirstrowID           Lastrowkey
*00FC   *0048  0000 0416 0404  0000 7BF7 3EA8 0000 0001  0000 7FF3 96E0
*0140   *0047  0000 0416 0404  0000 7FF3 FB5F 0000 0001  0000 83F2 F87B
*0185   *0045  0000 0416 0404  0000 83F3 5076 0000 0001  0000 87F6 77EE

Rebuilt [W]CI has overlapping [W]DBs.
Run REPAIRSECTS command to resolve overlapping [W]DBs

REBUILDCI ==>
repairsects
The rebuilt CI has overlapping DBs.
To resolve this issue, remove some of the overlapping DBs.
First resolve any DBs that have overlapping sectors.
Then resolve DBs that have overlapping rowids (if any still exist).
  Enter the Start sector of the overlapping DB to remove, or 
  Enter ‘0’ to quit

0140
Command has been sent to Slave tasks.

vproc 0 (0000) response

The specified [W]DBs have been deleted.

The DBs listed below have overlapping rowids:
Start Sectors      TableID             FirstrowID           Lastrowkey
 02DE    0045   0000 0416 0404  *0000 97F6 D26A 0000 0001  *0000 9BFB F9E2
 0323    0045   0000 0416 0404  *0000 9BFA 3405 0000 0001  *0000 9FFD BFFC

The rebuilt CI still has overlapping DBs.
Run REPAIRSECTS again to try to resolve the problem.
REBUILDCI ==>
repairsects
The rebuilt CI has overlapping DBs.
To resolve this issue, remove some of the overlapping DBs.
First resolve any DBs that have overlapping sectors.
Then resolve DBs that have overlapping rowids (if any still exist).
  Enter the Start sector of the overlapping DB to remove, or 
  Enter ‘0’ to quit

0323

Command has been sent to Slave tasks.

vproc  0 (0000)  response

The specified [W]DBs have been deleted.

REBUILDCI ==>