Recovering without using the BACKUP SYSTEM utility

You can recover your Db2 subsystem if you do not use the BACKUP SYSTEM utility to produce backups.

Procedure

To recover your Db2 subsystem without using the BACKUP SYSTEM utility:

  1. Prepare for recovery.
    1. Issue the Db2 command SET LOG SUSPEND to suspend logging and update activity, and to quiesce 32 KB page writes and data set extensions.

      For data sharing systems, issue the command to each member of the data sharing group.

    2. Use the FlashCopy® function to copy all Db2 volumes. Include any ICF catalogs that are used by Db2, as well as active logs and BSDSs.
    3. Issue the Db2 command SET LOG RESUME to resume normal Db2 activity.
    4. Use DFSMSdss to dump the disk copies that you just created to tape, and then transport this tape to the remote site. You can also use other methods to transmit the copies that you make to the remote site.
  2. Recover your Db2 subsystem.
    1. Use DFSMSdss to restore the FlashCopy data sets to disk.
    2. Run the DSNJU003 utility by using the CRESTART CREATE, SYSPITR=log-truncation-point control statement.

      The log-truncation-point is the RBA or LRSN of the point to which you want to recover.

    3. Restore any logs on tape to disk.
    4. Start Db2.
    5. Run the RESTORE SYSTEM utility using the RESTORE SYSTEM LOGONLY control statement to recover to the current time (or to the time of the last log transmission from the local site).