Restoring Db2 Databases to an Alternate Instance
Select a Db2® database backup and restore that database to a Db2 instance on an alternate host. You can also choose to restore a database to an instance with a different name, or you can rename the database. This process creates an exact copy of the database on a different host in a different instance.
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.
Db2 database backups are stored on the vSnap repository for instant access. If you want to back up to a single target volume exposed by the vSnap repository, you must configure Db2 with alternative paths for instant access.
To restore Db2 databases to an alternate location:
- From the navigation menu, expand Manage Protection, then expand Applications. Expand Db2, then click Restore.
- In the Restore window, click a Db2 instance from the list in the Instances pane to expand that instance to show the databases.
- Click the database that you want to restore to show the Restore Points available for that database.
- Restore points are listed with the backup timestamp, SLA policy type, and site information.
- In the Options panel, select Restore to alternate instance as the Destination choice. Select the target instance that you want to restore the data to.
- The original instance is not selectable as you cannot overwrite the original data when you select Restore to alternate instance. Instances on different versions levels cannot be selected either.
- If you want to create a copy of the database, rename the database in the New Database Name field.
- Select a Restore Type.
- Test. Choose this option to restore the data from the vSnap repository directly. This restore type could be used for short-lived restore operations for testing purposes.
- Production. Choose this option to restore the full database with a full-copy data restore operation. This restore operation is for permanent use of the restored database.
- Instant Access. Choose this option to mount the database backup to the target host. This mounted database can be used to access any particular log file or database that you want to back up elsewhere.
- 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.
- 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.
- 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.
- To restore immediately, click Restore.
- 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