Migrate from v7 to v9, 32 to 64 bit

[Ray]

Can someone provide some pointers to information regarding upgrading a
database from 32 bit V7 UDB to 64 bit V9 UDB on AIX hosts?

[dotyet]

i think you may have to first upgrade to version 8.x and then from 8.x
to version 9.x (but check the installation manual for clarity). moving
from 32-bit to 54-bit instance is pretty much straight forward. you
just have to specify what word-size you want for the instance.
however, by default, if the engine sees that the OS is 64-bit capable,
it will automatically create a 64-bit instance. you just have to
restore your database from an OFFLINE backup image. please make a
note, there is no turning back to v 7/8 once you have migrated to 9
since there are tonnes of structural changes in the engine. make sure
you run the bind over db2schema.bnd in the new database. you may also
have to increase your sql log file params temporarily while you are
migrating to 9. i guess thats most of it.... enjoy.

rgds,
dotyet

On Jun 20, 4:32 pm, Ray <[e-mail]:

Can someone provide some pointers to information regarding upgrading a
database from 32 bit V7 UDB to 64 bit V9 UDB on AIX hosts?

[Ray]

On Jun 21, 7:19 am, dotyet <[e-mail]:

i think you may have to first upgrade to version 8.x and then from 8.x
to version 9.x (but check the installation manual for clarity). moving
from 32-bit to 54-bit instance is pretty much straight forward. you
just have to specify what word-size you want for the instance.
however, by default, if the engine sees that the OS is 64-bit capable,
it will automatically create a 64-bit instance. you just have to
restore your database from an OFFLINE backup image. please make a
note, there is no turning back to v 7/8 once you have migrated to 9
since there are tonnes of structural changes in the engine. make sure
you run the bind over db2schema.bnd in the new database. you may also
have to increase your sql log file params temporarily while you are
migrating to 9. i guess thats most of it.... enjoy.

rgds,
dotyet

On Jun 20, 4:32 pm, Ray <[e-mail]:

Can someone provide some pointers to information regarding upgrading a
database from 32 bit V7 UDB to 64 bit V9 UDB on AIX hosts?

Thank you very much for your response. One (hopefully) last question.
Is there nothing special required to do the redirected restore into a
64 bit instance from a backup taken from a 32 bit instance?

[dotyet]

thats true... nothing special or extra.... just plane-jane restore.
just make sure you already have a target 64-bit instance in place.

regards,
dotyet

On Jun 25, 11:16 am, Ray <[e-mail]:

On Jun 21, 7:19 am, dotyet <[e-mail]:

i think you may have to first upgrade to version 8.x and then from 8.x
to version 9.x (but check the installation manual for clarity). moving
from 32-bit to 54-bit instance is pretty much straight forward. you
just have to specify what word-size you want for the instance.
however, by default, if the engine sees that the OS is 64-bit capable,
it will automatically create a 64-bit instance. you just have to
restore your database from an OFFLINE backup image. please make a
note, there is no turning back to v 7/8 once you have migrated to 9
since there are tonnes of structural changes in the engine. make sure
you run the bind over db2schema.bnd in the new database. you may also
have to increase your sql log file params temporarily while you are
migrating to 9. i guess thats most of it.... enjoy.

rgds,
dotyet

On Jun 20, 4:32 pm, Ray <[e-mail]:

Can someone provide some pointers to information regarding upgrading a
database from 32 bit V7 UDB to 64 bit V9 UDB on AIX hosts?

Thank you very much for your response. One (hopefully) last question.
Is there nothing special required to do the redirected restore into a
64 bit instance from a backup taken from a 32 bit instance?