You can easily restore offline backup images that are taken
on ESE to a DB2® pureScale® instance.
Before you begin
Before you can restore a
DB2 Enterprise
Server Edition database
backup to a
DB2 pureScale instance,
you can verify that your databases are ready for use in a
DB2 pureScale environment.
To verify that your ESE database is ready to restore to a
DB2 pureScale environment,
run the
db2checkSD command.
About this task
These requirements must be considered before you restore
a database from a
DB2 Enterprise
Server Edition instance
to a
DB2 pureScale instance:
- Only backups of consistent databases are supported.
- To be able to support recoverability from the point in time of
the restore operation, after you complete the restore operation, you
must take a new offline full database backup.
- The source and target instances must be from the same DB2 product level.
- The target member topology must include the member identifier
of the DB2 ESE instance.
Restrictions
If
you are restoring a backup image of an inconsistent database between
a
DB2 Enterprise
Server Edition instance
and a
DB2 pureScale instance,
as a workaround, you can either perform an offline backup on the source
instance or update the target instance to include a member identifier
in the source instance, then rerun the
RESTORE command.
Procedure
To restore a database from a DB2 Enterprise
Server Edition instance
to a DB2 pureScale instance:
- Optional: On the source instance
(ESE), run the db2checkSD command:
db2checkSD dbname -l filename -u userid -p password
At
this point, the db2checkSD command performs compatibility
checks that determine if the database can be used in a DB2 pureScale environment.
- Perform an offline database backup:
db2 backup database dbname to directory
- On the target instance (DB2 pureScale instance that
includes, for example, member 0 in the topology), restore the backup
on the DB2 pureScale instance with
members 0, 1, and 2 from member 0 (the common member).
db2 restore database dbname from directory without rolling forward
- On the target instance, run the db2checkSD command
again:
db2checkSD dbname -l filename -u userid -p password
Perform
the db2checkSD command to convert the database
so that it can be used in a DB2 pureScale environment. The
user ID must be the same as the user ID that has DATAACCESS authority
on the source instance.
- Optional: Perform either an incremental or full offline database backup
from member 0 (the common member) by issuing the following command:
db2 backup database dbname to directory
Results
The database is now usable.