Question about database migration from UDB 7.1 to 8.2 (FP3) on HP-UX

[tommydkat]

Hi! I need to migrate a UDB 7.1 32-bit database on one HP-UX system to
a 8.3 (FP3) 64-bit database on a new HP-UX system.

I found this newsgroup post which indicates this not possible using
backup/restore utilities:

http://groups.google.com/group/comp....5f06f1c877dca2

Is this still the case with UDB 8.2? I can't backup the database in
UDB 7.1 and restore it in UDB 8.2?

Thanks!

Peace...

[RV]

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

[leonardobgil]

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

[Darin McBride]

to*******@gmail.com wrote:

Hi! I need to migrate a UDB 7.1 32-bit database on one HP-UX system to
a 8.3 (FP3) 64-bit database on a new HP-UX system.

I found this newsgroup post which indicates this not possible using
backup/restore utilities:

http://groups.google.com/group/comp....5f06f1c877dca2
Is this still the case with UDB 8.2? I can't backup the database in
UDB 7.1 and restore it in UDB 8.2?

Thanks!

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.

[tommydkat]

Thanks for the help, guys!

Peace...

Tom

[tommydkat]

One more quick question, if I have an application that updates the DB2
database will I need to relink that application once the database is
migrated to the 64-bit DB2 V8.2 instance? The application was updating
the 32-bit DB2 V7 database.

Thanks!

Peace....

[leonardobgil]

You will need the version 8 runtime client installed on the application
server.

The runtime client should keep your old catalog intact, so you may not
have to re-catalog your database on the application server

[tommydkat]

Thanks for the info. I found another thread in this newsgroup that
addressed the issue I asked about above and found this technote:

http://www-1.ibm.com/support/docview...=utf-8&lang=en

That technote contains all the info I need so I think I'm set (at least
until I get to thep point of actually trying it out. :)).

These threads were very helpful:

http://groups.google.com/group/comp....eedc4f1e8eb291
http://groups.google.com/group/comp....62804cfdcf4e1b

Thanks again for the help!

Peace...