Before running REPAIR
Certain activities might be required before you run the REPAIR utility, depending on your situation.
Attention: Be extremely careful when using the REPAIR utility
to replace data. Changing data to invalid values by using REPLACE might produce
unpredictable results, particularly when changing page header information.
Improper use of REPAIR can result in damaged data, or in some cases, system
failure.
Making a copy of the table space
Before starting to use REPAIR to change data, ensure that you have a copy (full image copy or DSN1COPY generated copy) of the affected table space to enable fallback.
Restoring damaged indexes
Because REPAIR can access index data only by referring to a page and an offset within the page, identifying and correcting a problem can be difficult. Use REBUILD INDEX or RECOVER INDEX to restore damaged index data.
Running REPAIR on encrypted data
Do not run REPAIR on encrypted data. REPAIR does not decrypt the data. The utility reads the data in its encrypted form and then manipulates the data without decrypting it.