After running RESTORE SYSTEM

The effects of the RESTORE SYSTEM utility and the activities that might be required after it runs vary, depending on your situation.

Effects of running RESTORE SYSTEM

Recovering table spaces defined with NOT LOGGED attribute
If RESTORE SYSTEM utility determines that a table space defined with the NOT LOGGED attribute was updated after the point at which the system-level copy was taken, the table space or partition is marked RECOVER-pending.

After running RESTORE SYSTEM

Complete the following steps after running RESTORE SYSTEM:
  1. Stop and start each DB2® subsystem or member to remove it from access maintenance mode.
  2. Use the DISPLAY UTIL command to see if any utilities are running. If other utilities are running, use the TERM UTIL command to end them.
  3. Use the RECOVER utility to recover all objects in RECOVER-pending (RECP) or REBUILD-pending (RBDP) status, or use the REBUILD INDEX utility to rebuild objects. If a CREATE TABLESPACE, CREATE INDEX, or data set extension has failed, you can also recover or rebuild any objects in the logical page list (LPL).