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. 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.