RECOVER-pending status

RECOVER-pending (RECP) restrictive status indicates that a table space, table space partition, index space, or index on an auxiliary table is broken and must be recovered.

If a single logical partition is in RECP status, the partition is treated as RECP status for SQL access. A single logical partition in RECP status does not restrict utility access to other logical partitions that are not in RECP status. RECP status is reset by recovering only the single logical partition.

To reset RECP status, take the actions that are described in the following table.

Table 1. Resetting RECOVER-pending status
Status	Abbreviation	Object affected	Corrective action	Notes®
RECOVER- pending	RECP	Table space	Run the RECOVER utility on the affected table space.	^{1, 2}
RECOVER- pending	RECP	Table space partition	Run RECOVER on the affected partition.	^{1, 2}
RECOVER- pending	RECP	Index on the auxiliary table	Run one of the following utilities on the affected index: REBUILD INDEX RECOVER INDEX	^{1, 2}
RECOVER- pending	RECP	Index space	Run one of the following utilities on the affected index space: REBUILD INDEX RECOVER INDEX	^{1, 2}

Notes:

You can also reset RECP status by running LOAD REPLACE on the table space or partition. (The LOAD REPLACE method assumes that replacing the data is acceptable for your situation.)
If you need to remove the RECP status only, without correcting the underlying problem that caused the object to be placed in a restrictive state, you can take one of the following actions:
- Run the REPAIR utility SET statement with NORCVRPEND on the table space, partition, or index.
- Start the database that contains the table space or index space with ACCESS FORCE.
Be aware that these actions do not correct the data inconsistency in the index or index partition.