HHH
HHH

Reputation: 6485

How to migrate a db2 database

I have a db2 database on a device which does not have internect connectivity and would like to move this database to another place. I have taken a backup from my database, can I use the 'restore' command to create a clone of this database?

Upvotes: 0

Views: 1127

Answers (1)

Paul Vernon
Paul Vernon

Reputation: 3911

To move a Db2 database from on-premise to Db2 Warehouse on Cloud, one option is to use IBM Lift CLI. https://www.lift-cli.cloud.ibm.com/

You will need to have internet connectivity from the place your data resides on-premise - either a Db2 database, or failing that CSV files.

If all you have is a Db2 backup image, you would need to restore that into a local database, or use the (chargeable) utility High Performance Unload to extract table data as CSV files from the backup image. IBM Lift CLI does not support Db2 backup images as a source for migration to the cloud.

Note that if you use CSV files, you will need to extract the DDL from the source database and create the empty tables on the target.

Upvotes: 1

Related Questions