Restore of offline backup images that are taken on DB2® pureScale® instance to DB2 Enterprise
Server Edition ,
without roll forward support through the transition.
About this task
Consider the following before you restore a database
from a
DB2 pureScale instance to
a
DB2 Enterprise
Server Edition instance:
- Only backups of consistent databases are supported.
- To be able to support recoverability from the point in time of
the restore operation, after completing the restore operation, you
must take a new offline 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 from
a
DB2 pureScale Feature to a
DB2 Enterprise
Server Edition instance,
as a workaround, you can first perform a full database backup on the
source instance, then restore the full database backup by running
the
RESTORE command.
Procedure
To restore a database from a DB2 pureScale instance to
a DB2 Enterprise
Server Edition instance:
- On the source instance (DB2 pureScale instance with,
for example, members 0 and 1), perform an offline database backup:
db2 backup database sample to /dev3/backup
- On the target instance (ESE, member 0), perform a restore:
db2 restore database sample from /dev3/backup without rolling forward
- Perform an offline database backup:
db2 backup database sample to /dev3/backup
Results
The database is now usable.