database restore to other LPAR

IBM's flagship relational database management system

database restore to other LPAR

Postby jaggz » Thu Jun 23, 2011 12:37 pm


we have installed a new DB2 V10.1 in a new LPAR(Z/OS). we have planned to migrate all the DB2 8.1 database ,tablespace to the new LPAR with DB2 V10.1. Just wanted to know if the Dump and restore will be a good option. Also, LOAD and UNLOAD options too we have kept for restore.
User avatar
Posts: 356
Joined: Fri Jul 23, 2010 8:51 pm
Has thanked: 8 times
Been thanked: 5 times

Re: database restore to other LPAR

Postby GuyC » Thu Jun 23, 2011 1:15 pm

"Dump" ? is that a new db2 utility ?
BACKUP SYSTEM is a v9 feature and i don't think you can go cross versions with that, especially because the catalog has undergone big changes.
I would do it with "a generated DDL" defining all structures inside the DB2 v10 and then use DNS1COPY
Unless you still have simple tablespaces. Those you can't define in v10 and there you would need to unload/load.
I can explain it to you, but i can not understand it for you.
Posts: 315
Joined: Tue Aug 11, 2009 3:23 pm
Has thanked: 1 time
Been thanked: 4 times

Return to DB2


  • Related topics
    Last post