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 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.
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.
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.

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 partitions 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
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. You can also reset 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.)
  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