Restoring Db2 Databases to the Original Location

Restore a database backup to its original instance on the original host. Choose between restoring to the latest backup or an earlier Db2® database backup version. When you restore an instance or a database to its original location, you cannot rename it. This restore option runs a full production restoration of data, and existing data is overwritten at the target site.

Before you begin

Before you start, ensure that you allowed enough disk space and allocated dedicated volumes for the copying of files.

Tip: If the local database directory you are restoring to is not empty and the Overwrite Databases is not selected, the restore process fails. No other data can share the local database target directory as the database to be restored.

Important: If the local database directory you are restoring to is not empty and the Overwrite Databases is selected, the restore process overwrites that existing data.

Ensure that the following requirements are in place before you start.

  • The target database directory that you are restoring is clean and ready for the restore operation. Selecting Overwrite exisiting database in the Application Options panel overwrites data in the directory.
  • At least one Db2 backup job is set up and running. For instructions on how to set up a backup job, see Defining an SLA Backup Job.
  • IBM Spectrum Protect™ Plus roles and resource groups are assigned to the user who is setting up the restore job. For more information about assigning roles, see Access.

To restore Db2 databases to the original location:

  1. From the navigation menu, expand Manage Protection, then expand Applications. Expand Db2, then click Restore.
  2. In the Restore window, click a Db2 instance from the list in the Instances pane to expand that instance to show the databases.
  3. Click the database that you want to restore to show the Restore Points available for that database.
  4. Restore points are listed with the backup timestamp, SLA policy type, and site information.
  5. Click Options. In the Destination panel, select Restore to original instance for the production restore operation.
  6. The Restore Type is already selected as Production; there are no other choices for restoring to the original location.
  7. Select Recovery Options for the restore operation. The default value is No Recovery.
    • No Recovery. This option skips any rollforward recovery after the restore operation. The database remains in a Rollforward pending state until you decide whether you want to run the rollforward manually.
    • Recover until end of backup. This choice recovers only the data that is contained in the backup that is selected.
    • Recover until end of available logs. This choice recovers data in the backup and right through to the last backup as captured in the continuous logs. This option is only available if you selected Enable Log Backup in the backup job.
    • Recover until specific point in time. This option includes all the backup data up to a specific point in time, for example, May 8, 2018 12:18:00 AM. This option is only available if you selected Enable Log Backup in the backup job.
  8. Specify Application Options to choose extra options.
    • Overwrite existing databases. Choose this option to clean up the database and overwrite any data that exists before you restore to that location. You do not need to select this option when the directory is clear of existing data.
    • Note: Ensure that no other databases are sharing this directory or that data is overwritten when this choice is selected.
    • Maximum Parallel Streams per Database. If required you can choose to run the restore operation of data in parallel streams. This option is useful when you are restoring a large database.
    • Specify the size of the Db2 database memory set in KB. Input the size in kilobytes
  9. Choose to specify further restore options in the Advanced Options pane. Both options are selected by default.
    • Run cleanup immediately on job failure. If the restore operation fails, this option enables a cleanup of the allocated resources.
    • Continue with restores of other selected databases even if one fails. If one database in the instance fails to restore successfully, the process continues for all other databases that are being restored.
  10. To restore immediately, click Restore.
  11. Alternatively, click Manage Jobs to specify a schedule for the restore operation you specified.

 


IBM Spectrum Protect Plus 10.1.2

Licensed Material - Property of IBM Corp. © IBM Corporation and other(s) 2018. IBM is a registered trademark of the IBM Corporation in the United States, other countries, or both. | 8/23/2018