Recovering with the BACKUP SYSTEM and RESTORE SYSTEM utilities

You can use the BACKUP SYSTEM and RESTORE SYSTEM utilities to recover your Db2 subsystem.

To recover your Db2 subsystem:

1. Prepare for recovery:
   1. Use BACKUP SYSTEM FULL to take the system backup.
   2. Transport the system backups to the remote site.
2. Recover:
   1. Run the DSNJU003 utility using either of the following control statements:
      • In this control statement, substitute log-truncation-point with the RBA or LRSN of the point to which you want to recover

        CRESTART CREATE, SYSPITR=log-truncation-point

        where .
      • In this control statement, substitute log-truncation-timestamp with the timestamp of the point to which you want to recover.

        CRESTART CREATE,SYSPITRT=log-truncation-timestamp

   2. Start Db2.
   3. Run the RESTORE SYSTEM utility by issuing the RESTORE SYSTEM control statement.

      This utility control statement performs a recovery to the current time (or to the time of the last log transmission from the local site).