2) Yes you can take a V 8.x 64 bit image and restore it on a V 8.x 32 bit system.
===========
If for some reason, we have to migrate the 32bit V7.2 db2 server (aix 5.2) to 32bit V8.1 db2 server (aix 5.2)first. Then if we want to convert the 32bit V8.1 db2 server to 64bit V8.1 db2 server, Do I have to use BACKUP/RESTORE? Is there any other way to do this?
Thanks,
FRX
"Dale McInnis" <dmcinnis@ca.ibm.com> wrote in message news:bvjbbv$klb$1@hanover.torolab.ibm.com...
VKG
1) Yes you can take a 32 bit V 7.2 image and restore it to a 32 bit V 8.x system
2) Yes you can take a V 8.x 64 bit image and restore it on a V 8.x 32 bit system.
regards,
Dale McInnis
Vikrant wrote:
Friends,
I have read DB2/UDB 8.x 'RESTORE DATABASE Command', with my 'limited'
knowledge & skill. I think it should address my concern, but I want
advice/ opinion / experience and any care I must take to restore
DB2/UDB 8.x database 64 to 32 bit).
(1) Due to hardware limitaion I can not have 64 bit DB2/UDB 8 on AIX
4.3.3 host. Let us call this as host vhost32. I can migrate 7.2EE
FP11 32bit to 8.x 32 bit on vhost32. This is my test system.
Operating system on vhost32 is AIX 4.3.3 ML09.
(2) on my production host, let us call it lhost64. Its P630, 64 bit
AIX 5.2 ML01, and DB2/UDB 8.x in 64 bit mode.
To resolve any 'unforeseen' production problem, I want to restore
production database (created by db2 backup db command under DB2/UDB
8.x)from lhost64 (DB2/UDB 8.X 64 bit, AIX 5.2ML01) to vhost32 onto
DB2/UDB 8.x 32 bit under AIX 4.3.3 ML01.
Can I do it or not ?
Enjoy,
VKG
===================
rom: Kelly D. Rodger
Join Bytes!
Newsgroups: comp.databases.ibm-db2
Date: 2003-06-23 15:15:05 PST
Right. V7 Sun/HP backup images are only compatible with Sun/HP, and
only to instances of the same word size.
In V8, AIX/Sun/HP backup images are now all compatible, even across 32
and 64-bit sizes, but this is ONLY for V8 backup images and does not
apply to backup images produced with V7 or earlier releases. This is
all be covered in the books, although I don't have a URL handy right
now.
Can one backup a 6.1 instance and restore to 7.2?
I'm pretty sure this is OK. The database is implicitly migrated at the end
of the restore.
Yes, you can restore any backup image from a release that you can
migrate from - check the docs if you're unsure about which downlevel
releases are supported.
Hope that helps.
kdr
