Restoring data using the Restore wizard - IBM DB2 9.7 for Linux, UNIX, and Windows

You can use the Restore wizard to restore and roll forward databases or database partitions.

Before you begin

Note: You can perform this task using IBM® Data Studio. For more information, follow the Data Studio related link.

Before you can restore a database you must have an exclusive connection; that is, no applications can be running against the database when the task is started. Once it starts, it prevents other applications from accessing the database until the restore is completed.

To restore a database or a database partition, you must have SYSADM, SYSCTRL, or SYSMAINT authority.
To restore to a new database, you must have SYSADM or SYSCTRL authority.
To restore a table space or table space partition, you must have SYSADM, SYSCTRL, or SYSMAINT authority.

About this task

Use the Restore wizard to perform any of the following tasks:

Restore a database or database partition
Roll forward a database or database partition
Restore a database backup image to a new database
Restore the history file for a database
Restore a table space or table space partition
Roll forward a table space or table space partition

Note: You cannot transport table spaces and schemas using the Restore wizard.

First you specify the objects you want to restore and select the image that you want to use, then you make more advanced choices.

Procedure

Open the Restore wizard:
- To restore a database partition, open the Restore wizard from the database object.
- To restore a table space partition, open the Restore wizard from the table space object.
1. From the Control Center, expand the object tree until you find the database or table space object that you want to restore.
2. Right-click the object and select Restore from the pop-up menu. The Restore wizard opens.
Complete each of the applicable wizard pages. Click the wizard overview link on the first page for more information. The Finish push button is available when you complete enough information for the wizard to restore the objects in your database.