Page 1 of 1

database restore to other LPAR

PostPosted: Thu Jun 23, 2011 12:37 pm
by jaggz
Hi,

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.

Re: database restore to other LPAR

PostPosted: Thu Jun 23, 2011 1:15 pm
by GuyC
"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.