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.
In this situation, the last partition of the table space is set to REORG-pending (REORP) restrictive status.
Start of changeREBUILD-pending star (RBDP*) statusEnd of change
Start of changeIndicates 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.End of change
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.
Start of changeAdvisory REBUILD-pending (ARBDP) statusEnd of change
Start of changeIndicates 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.End of change

To reset REBUILD-pending status, take the actions that are described in the following table.

Table 1. Resetting REBUILD-pending status
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 Start of changeRun 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.)End of change 1, 2, 3, 4
Start of changeAdvisory REBUILD-pendingEnd of change 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: Start of change
  1. Rebuilding an index and thereby resetting the REBUILD-pending status invalidates the dynamic statement cache for the related table.
  2. If you alter the data type of a column to a numeric data type, RECOVER INDEX cannot complete. You must rebuild the index.
  3. Start of changeYou 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.)End of change
  4. 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.
    Be aware that these actions do not correct the data inconsistency in the index or index partition.
End of change