Restart-pending status

Restart-pending status indicates that an object has backout work pending at the end of a Db2® restart. Backout activity against the objects must be completed.

Objects in RESTP status are unavailable. You cannot use LOAD REPLACE on an object that is in the RESTP status. You also cannot run any utilities against page sets or partitions with RESTP status. Any attempt to access a page set or partition with RESTP status terminates with return code 8.

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

Table 1. Resetting restart-pending status
Status Abbreviation Object affected Corrective action
Restart- pending RESTP Table space, table space partitions, index spaces, and physical index space partitions
Perform one of the following actions:
  • Use the RECOVER POSTPONED command.
  • Restart the Db2 subsystem with the LBACKOUT subsystem parameter set to AUTO.

Delay running REORG TABLESPACE SHRLEVEL CHANGE until all RESTP statuses are reset.