Resetting index space status

In most cases, resetting restrictive states on index spaces by using methods other than the REPAIR utility is preferable.

For informational COPY-pending status, running COPY INDEXSPACE to reset the status is preferable to using the REPAIR utility.

For REBUILD-pending status, consider using the REBUILD INDEX or RECOVER INDEX utility rather than running REPAIR SET INDEX NORBDPEND. RECOVER uses Db2-controlled recovery information, whereas REPAIR SET INDEX resets the REBUILD-pending status without considering the recoverability of the index. Recoverability issues include the availability of image copies, rows in SYSIBM.SYSCOPY, and log data sets.