Restart-pending status
If an object has backout work pending at the end of DB2® restart, the object is placed in restart-pending (RESTP) status.
You cannot use LOAD REPLACE on an object that is in the RESTP status.
Utility activity against page sets or partitions with RESTP status is not allowed. Any attempt to access a page set or partition with RESTP status terminates with return code 8.
The following table explains how to reset the restart-pending status.
| Status | Abbreviation | Object affected | Corrective action |
|---|---|---|---|
| Restart- pending | RESTP | Table space, table space partitions, index spaces, and physical index space partitions | Backout activity against the object must be completed. Either use the RECOVER POSTPONED command or restart the DB2 subsystem with the subsystem parameter LBACKOUT set to AUTO. Objects in the RESTP status remain unavailable until backout work is complete, or until restart is canceled and a conditional restart or cold start is performed in its place. Delay running REORG TABLESPACE SHRLEVEL CHANGE until all RESTP statuses are reset. |