REBUILD-pending status
A REBUILD-pending restrictive status indicates that the affected index or index partition is broken and must be rebuilt from the data.
The following REBUILD-pending states can be set:
- REBUILD-pending (RBDP) status
- Indicates that the physical or logical index partition is inaccessible and must be rebuilt.
For example, RBDP status is set on a data-partitioned secondary index if you create the index after performing the following actions:
- Create a partitioned table space.
- Create a partitioning index.
- Insert a row into a table.
- REBUILD-pending star (RBDP*) status
- Indicates that a logical partition of a nonpartitioned secondary index is unavailable for read-write access and the entire index is unavailable for read access. The related table is unavailable for insert or update operation if the index is unique and one or more logical partitions in the index is in REBUILD-pending star status.
- Page set REBUILD-pending (PSRBD) status
- Indicates that an entire nonpartitioned secondary index or index on the auxiliary table is unavailable for read-write access.
- Advisory REBUILD-pending (ARBDP) status
- Indicates that the index should be rebuilt. For example, ARBDP status is set when indexes with varying length columns are changed from VARYING NO to VARYING YES.
To reset REBUILD-pending status, take the actions that are described in the following table.
Status | Abbreviation | Object affected | Corrective action | Notes® |
---|---|---|---|---|
REBUILD- pending | RBDP | Physical or logical index partition | Run the REBUILD INDEX utility on the affected index partitions. | 1, 3, 4 |
REBUILD- pending star | RBDP* | Logical partition of nonpartitioned secondary indexes | Run REBUILD INDEX PART or the RECOVER utility on the affected logical partitions. | 1, 2, 3, 4 |
Page set REBUILD- pending | PSRBD | Nonpartitioned secondary index (NPSI) or index on the auxiliary table | Run RECOVER or REBUILD INDEX on the entire affected index. (You cannot run REBUILD INDEX PART to rebuild one logical partition of an NPI in PSRBD.) | 1, 2, 3, 4 |
Advisory REBUILD-pending | ARBDP | Index |
Run REBUILD INDEX. Alternatively, if the ARBDP was set as a result of an ALTER statement, run the REORG INDEX utility. |
1, 3 |
Notes:
- Rebuilding an index and thereby resetting the REBUILD-pending status invalidates the dynamic statement cache for the related table.
- If you alter the data type of a column to a numeric data type, RECOVER INDEX cannot complete. You must rebuild the index.
- You can also reset ARBDP, RBDP, RBDP*, or PSRBD status by running REORG TABLESPACE on the associated table space or 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 RBDP, RBDP*, or PSRBD 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 INDEX statement with NORBDPEND on the index partition. Use the CHECK INDEX utility to identify inconsistencies between the index and table space and the CHECK DATA utility to check referential integrity constraints.
- Start the database that contains the index space with ACCESS FORCE.