Recovering by using Db2 restart recovery

If you created a backup by using the BACKUP SYSTEM utility, you can recover your Db2 subsystem to the point in time of the backup by using normal Db2 restart recovery.

Procedure

To recover your Db2 system to the point in time of a backup:

  1. Back up your system by issuing the BACKUP SYSTEM FULL command.

    DFSMShsm maintains up to 85 versions of system backups on disk at any given time.

  2. Recover the system:
    1. Stop the Db2 subsystem. For data sharing systems, stop all members of the group.
    2. Use the DFSMShsm command FRRECOV * COPYPOOL(cpname) GENERATION(gen) to restore the database and log copy pools that the BACKUP SYSTEM utility creates. In this command, cpname specifies the name of the copy pool, and gen specifies which version of the copy pool is to be restored.
    3. For data sharing systems, delete all CF structures that are owned by this group.
    4. Restore any logs on tape to disk.
    5. Start Db2. For data sharing systems, start all active members.
    6. For data sharing systems, execute the GRECP and LPL recovery, which recovers the changed data that was stored in the coupling facility at the time of the backup.