By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,590 Members | 2,191 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,590 IT Pros & Developers. It's quick & easy.

Migrate from v7 to v9, 32 to 64 bit

P: n/a
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?

Jun 20 '07 #1
Share this Question
Share on Google+
3 Replies


P: n/a
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 <mcva...@gmail.comwrote:
Can someone provide some pointers to information regarding upgrading a
database from 32 bit V7 UDB to 64 bit V9 UDB on AIX hosts?

Jun 21 '07 #2

P: n/a
Ray
On Jun 21, 7:19 am, dotyet <dot...@yahoo.comwrote:
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 <mcva...@gmail.comwrote:
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?

Jun 25 '07 #3

P: n/a
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 <mcva...@gmail.comwrote:
On Jun 21, 7:19 am, dotyet <dot...@yahoo.comwrote:
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 <mcva...@gmail.comwrote:
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?

Jun 25 '07 #4

This discussion thread is closed

Replies have been disabled for this discussion.