Resetting RECOVER-pending or REBUILD-pending status
Several possible operations on a table space can place the table space in the RECOVER-pending status and the index space in REBUILD-pending status.
Procedure
To reset RECOVER-pending or REBUILD-pending status:
Use one of the following methods:
- Recover the table space, index space, or partition.
- Use REBUILD INDEX to rebuild the index space from existing data.
- Use the LOAD utility, with the REPLACE option, on the table space or partition.
- Use the REPAIR utility, with the NORCVRPEND option, on the table space, index space, or partition. Be aware that the REPAIR utility does not fix the data inconsistency in the table space or index.
- Rebuild indexes, run REORG TABLESPACE SORTDATA for table spaces and indexes.