Restoring DB2 data

Before you restore DB2 resources, make sure that you have completed all of the preparations for installing and configuring the DB2 Agent.

See Installation and configuration requirements for the DB2 Agent.

Note:

In a CASO environment, you can delegate a DB2 restore job to a managed media server. However, if the restore job uses encrypted DB2 backup sets from which to restore, the restore job may fail. An error message may appear that indicates the managed media server does not have the required encryption keys necessary to complete the job. You must create the encryption keys on the managed media server that runs the restore job.

See Creating an encryption key.

To restore DB2 data

  1. On the navigation bar, click the arrow next to Restore.

  2. Click New Restore Job.

  3. On the Properties pane, under Source, click Selections.

  4. Click the View by Resource tab.

  5. Expand the All Resources icon.

  6. Expand the system resource that contains the database instance that you want to restore.

  7. Do one of the following:

    To restore the entire database

    Check Current Database.

    If the database is offline, the Current Database is empty and you cannot make selections.

    To restore a backup set

    Check a backup set, or a historical set.

    To restore a table space

    Expand either Current Database or a backup set, and then check any of the table spaces that you want to restore.

  8. On the properties pane, under Settings, click DB2.

  9. Complete the appropriate options as follows.

    Restore database from full and/or incremental backups

    Check Restore database from full and/or incremental backups to enable restore options.

    To the most recent available

    Select this option to restore the DB2 database to the most recent full and incremental backups that are available.

    To a point in time

    Select this option to restore data up to and including a point in time that is in the job log. After the point in time, recovery stops.

    In the Date box, select the part of the date that you want to change, and then enter a new date or click the arrow to display a calendar from which you can select a date.

    In the Time box, select the part of the time that you want to change, and then enter a new time or click the arrows to select a new time.

    Roll forward using logs

    Check Roll forward using logs to enable a restore of a database that has archive logging enabled. To restore a database completely, you must also check Restore from full and/or incremental backups.

    You can restore the database, and then perform the roll forward operation later.

    For databases that have circular logging enabled, you must uncheck Roll forward using logs or the job will fail.

    To the most recent available

    Select this option to roll the DB2 database forward to the most recent logs that are available.

    To a point in time

    Select this option to restore logs up to and including a point in time. After the point in time, recovery stops.

    In the Date box, select the part of the date that you want to change, and then enter a new date or click the arrow to display a calendar from which you can select a date.

    In the Time box, select the part of the time that you want to change, and then enter a new time or click the arrows to select a new time.

    Override default log file path on DB2 server for this job

    Specify an alternate log file path location to search for archive log files during the roll forward operation. You should specify an alternate location if archive log files were moved to a location other than the location that was specified by the logpath database configuration on the destination DB2 server. Type the full path for the archive logs location.

    Selecting this option does not change the archive log path configuration on the DB2 server.

    Bring database online when finished rolling forward

    Check Bring database online when finished rolling forward to ensure that the database is brought online as soon as the recovery is finished.

  10. Select other restore options from the Properties pane as appropriate, and then start the restore job.

    See Restoring data by setting job properties.

  11. Run a full backup of the restored database.

More Information

Setting application defaults for DB2

About troubleshooting DB2