16.10 - REPAIRSECTS - 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 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: Using the Filer REPAIRSECTS command

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 ==>