I am planning to perform a database clone copy move from our old server to the new database server. How would I perform a redirected restore from serverA to serverB or is there a better method to do this? This will be part of the server move and database migration from old hardware using DB2 7.2 on AIX 5.2 to new RS6000 hardware and a database upgrade to 8.1.2 DB2 UDB on AIX 5.2.

Steps planned:
1. install and configure DB2 UDB 8.1.2 on new hardware

2. migrate existing DB2 database instance and databases to over to new database server

3. perform database upgrade/migration

Thanks

Scott

If you dont have any other database objects that may have to be migrated then export the data in del format and import it back on the new database which was set up in V8.
or

Install v7 on your new hardware and do the redirected restore and migrate the instance and apply the fixpacks upto 3

So should I install DB2 7.2 first before loading DB2 8.1.2 on the new server hardware? Is it possible to load data from V7.2 UDB into DB2 UDB 8.12? Thanks!

I suggest
1. Take v7 backup (old box)
2. Restore v7 backup on v8 (new box). During restore automatic db migration will be done


There is not need for v7 install on a new box

However, there is something about indexes - if I recall correctly, if you restore a v7 backup to v8 and wish to benefit from the v8 type 2 indexes then you will have to drop and recreate all indexes.

Another thing that comes to mind is that if you have data fragmentation, you can take this opportunity to remove it by export-load though ofcourse, it will be a slower process. There are other challenges to using this method if the system is MPP.

In DB2 V8, REORG INDEXES will always convert type-1 indexes to
type-2 indexes unless you are using the CLEANUP option.

But won't a drop and create be faster?

Great thanks here is what I have thus far:

1. Install DB2 UDB V8.1.2 on new server
2. Extract DDL from old database server (use db2look)
3. Create database on new server with ddl
4. Restore old database v7.2 to new database server
5. Test to see if all works.

I do not understand why you need steps 2. DB backup contains all required ddls. The only thing you need to do is redirect containers during restore.

-dmitri

I agree. I was thinking of disk and filesystem layout which I will need with the DB2 installation anyhow. Thanks again.

Scott