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.
| 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:
Delay running REORG TABLESPACE SHRLEVEL CHANGE until all RESTP statuses are reset. |