467,923 Members | 1,756 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 467,923 developers. It's quick & easy.

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?

Jun 20 '07 #1
  • viewed: 2806
Share:
3 Replies
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
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
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.

Similar topics

5 posts views Thread by Phil Powell | last post: by
6 posts views Thread by Jeffrey Todd | last post: by
3 posts views Thread by VS | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.