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