REPAIR options

The REPAIR online utility repairs data. REPAIR is intended as a means of replacing invalid data with valid data.

About this task

CAUTION:

Use caution in using REPAIR, as already damaged data could be further compromised if REPAIR is improperly used.

A portion of the Repair options panel is shown in the following figure. Press PF8 (DOWN) to view additional fields.

Figure 1. Repair options panel

 AUTOXPRT V1R1 -------------- Repair Options ------------- 2023/10/20  14:21:44 
 Option  ===>                                                                   
   Creator: TWUSR      Name: DAJ-13639 DB2 13 KEYWORDS        User: TWUSR       
                                                     Db2 Subsystem: SS01        
                                                                    More:     + 
    Exception Rule  . . . . . . . A  (A - Accepted, R - Rejected, B - Both)     
    Utility ID  . . . . . . . . .                   (16 characters)             
    Log . . . . . . . . . . . . . Y  (Yes/No)                                   
    Process . . . . . . . . . . . S  (S - Set, D - Dbd, L - Levelid             
                                      I - Insert Version Pages)                 
    No Copy Pending . . . . . . . N  (Yes/No)                                   
    No Recover Pending  . . . . . N  (Yes/No)                                   
    No Check Pending  . . . . . . N  (Yes/No)                                   
    No Auxiliary Warning  . . . . N  (Yes/No)                                   
    No Auxiliary Check Pending    N  (Yes/No)                                   
    No Rebuild Pending  . . . . . N  (Yes/No)                                   
    No Advisory Reorg Pending . . N  (Yes/No)                                   
    No Advisory Reorg Pending*    N  (Yes/No)                                   
    Rebuild Pending . . . . . . . N  (Yes/No)                                   
    Page Set Rebuild Pending  . . N  (Yes/No)                                   
    Repair Catalog  . . . . . . . N  (Yes/No)                                   
    Repair Catalog Test . . . . . N  (Yes/No)

Procedure

Set the Exception Rule field.
Enter the type of REPAIR to be done in the Process field.
1. To reset pending statuses, enter S in the Process field.
  Then specify the status to be reset in one or more of the fields that follow the Process field.
2. To repair a DBD, enter D in the Process field.
  In addition, specify the type of repair to be done in the DBD Process Option field.
3. To reset the level identifier of a table space partition, index, or index space partition, enter L in the Process field.
4. To insert missing version zero system pages to ensure that the table space or partition is self describing, enter I in the Process field.
  In addition, set the desired values in the Set Current Version and SHRLEVEL Change fields.
To log the changes made by the REPAIR utility, enter Y in the Log field.
Set other fields on the panel as desired.
Refer to the help panel for detailed information about the fields on this panel.