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

Clearification of 32 and / or 64 DB2/UDB 8.X backup restore under AIX 4.3 and AIX5.2

P: n/a
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 kr*****@ca.ibm.com
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
Nov 12 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
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 kr*****@ca.ibm.com
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


Nov 12 '05 #2

P: n/a
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" <dm******@ca.ibm.com> wrote in message news:bv**********@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 kr*****@ca.ibm.com
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

Nov 12 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.