The Home of C&P Software on the Web

DB2 MOVE a DB from one OS to another OS

As you are aware, DB2 backups cannot be restore on a different OS, so to do this DB2 provides a separate mechanism called “move”. Here is a step by step procedure to use db2move.

1. db2look -d -e -l -x -o db2look.sql
2. db2move export
3. tar / gz output
4. transfer to new server
5. untar / gz
6. create db
7. Remove the Foreign Keys from the sql file and put them separate in another sql file
8. db2 -tvf db2look.sql
9. db2move import
10. db2 -tvf db2indexes.sql
11. db2 activate database

Et voila!

P.S.:  This works well for small databases with no BLOBs or CLOBs...  Later I will publish a different method using a remote database configuration and cursors which is more efficient and a whole lot faster.