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.
- From the Control Center, expand the object tree until
you find the database or table space object that you want to restore.
- 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.