Restore Data - DB2 DPF - How To
Topics |
How To |
Full System
Restore |
Related Topics
Rerun a Failed DB2 or DB2 DPF Restore Job
Restore a DB2 Database or DB2
DPF Database Partition Created in a User-defined Directory
Restore a DB2 Database or
DB2 DPF Database Partition with Specific Parameters Containing a Non-default Value
Rerun a Failed DB2 or DB2 DPF Restore Job
Before You Begin:
- Review the general and agent-specific restore requirements accessed from
Restore Backup Data
prior to performing any restore operation.
Required Capability: See
Capabilities and Permitted Actions
To rerun a
restore job containing multiple backup images after the full backup image
restore failed:
- From the Restore Arguments tab of the Restore Options dialog box, enable
the Incremental Restore (from one Full backup image) option.
- Select only the full backup image that failed to restore from the
Available Images field.
- Click Advanced.
- From the Roll-Forward tab of the
Advanced Restore Options dialog box, select the
Leave in Roll-Forward Pending State option.
- Click OK to restore the full backup image.
- From the Restore Arguments tab, disable the Incremental Restore (from one
Full backup image) option.
- Select the next (non-full) backup image in the backup cycle from the
Available Images field.
- Click OK to restore this backup image.
- Repeat the previous two steps until all the other backup images in the
cycle have been restored.
- Click Advanced.
- Apply the database roll-forward from the
Roll-Forward tab.
- Continue the restore.
To
rerun a restore job containing multiple backup images after either a delta
backup image restore or an incremental backup image restore failed:
- From the Restore Arguments tab of the Restore Options dialog box, disable
the Incremental Restore (from one Full backup image) option.
- Select the backup image that failed to restore from the Available Images
field.
- Click OK to restore this backup image.
- Select the next backup image in the backup cycle from the Available Images
field.
- Click OK to restore this backup image.
- Repeat the previous two steps until all the other backup images in the
cycle have been restored.
- Continue the restore.
Restore a DB2 Database or
DB2 DPF Database Partition Created in a User-defined Directory
Before You Begin:
- Review the general and agent-specific restore requirements accessed from
Restore Backup Data
prior to performing any restore operation.
Required Capability: See
Capabilities and Permitted Actions
To restore a
database that you created at a user-defined directory location instead of at the
DB2 default location:
- Refer to
Browse and Restore or
Basic Restore as appropriate to
restore the database.
- Click Advanced.
- Ensure that you redirect all the associated tablespaces by using the
Redirect tab within the Advanced Restore Options dialog box.
- Continue the restore.
Restore a DB2 Database
or DB2 DPF Database Partition with Specific Parameters Containing a Non-default Value
Before You Begin:
- Review the general and agent-specific restore requirements accessed from
Restore Backup Data
prior to performing any restore operation.
Required Capability: See
Capabilities and Permitted Actions
To restore a
database whose DBHEAP,
UTIL_HEAP, and/or
APP_CTL_HEAP_SZ configuration parameters
contain a value other than the default value:
- Create a dummy database.
- Set the DBHEAP,
UTIL_HEAP, and/or
APP_CTL_HEAP_SZ configuration parameters
for this database to the (non-default) value of each of these parameters for
the source database.
- Restore the source database backup image to the dummy database. Refer to
Browse and Restore or
Basic Restore as appropriate.