Restore from Db2 Enterprise Server Edition to Db2 pureScale instance

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:

  1. 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.
  2. Perform an offline database backup: 
    db2 backup database dbname to directory
  3. 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
  4. On the target instance, run the db2checkSD command again: 
    db2checkSD dbname -l filename -u userid -p password
    At this point, the db2checkSD command performs the conversion of 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.
  5. 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.