Hi tommy,

If at all ur 32 bit Database is of version 8 then only u can do like
that (using backup and restore).

You can migrate ur Database by using the db2look and db2move utility
ie.. the method of regenereating the DDL and then u can create in ur
migrated database. then u can load the data using db2move utility.

RV

Basically you will do this:

1 - Take an offline backup of your v7 database
2 - Create a 32 bit instance on your v8
3 - Restore the offline backup into the v8 database
4 - Update your instance to 64bit (db2iupdt -w 64 instance_name)
5 - Reorg all indexes with the convert option (this will convert all
the old indexes from type1 to type2).

You cannot use an online backup because the logs are not compatible
between v7 and v8, and you cannot restore directly to a 64bit instance,
you have to restore to a 32 bit then update it.

Make sure you convert the indexes to type-2 so you can take advantage
of the performance features of type-2

Good luck,

Leo

Thanks for the link to the old thread.  That comes in very handy when trying
to figure out what the question is ;-)

The way to migrate your v7 database to v8 is to keep the bits the same.  The
best way to do this, I think, is to change your v8 instance to 32-bit (use
db2iupdt with the "-w 32" flag), restore the database, then convert your v8
instance back to 64-bit (using db2iupdt with the "-w 64" flag).

I would imagine that if you wanted to do all this without taking down your
existing 64-bit instance, you probably could create a new 32-bit instance,
restore, optionally convert that instance to 64-bit, backup again (the new
backup will be a v8 backup which is not dependant on wordsize), and then
restore that to your production instance.

Hope that helps.