467,927 Members | 1,845 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

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

Can we restore redirect a db2 version 7.2 backup to db2 version 8.1

Jag
Hi all,
I am trying to see if backup taken at db2 V7.2 can be restore redirected on V8

any one faced this problem??
regards,
jag
Nov 12 '05 #1
  • viewed: 2017
Share:
4 Replies
Ian
Jag wrote:
Hi all,
I am trying to see if backup taken at db2 V7.2 can be restore redirected on V8

any one faced this problem??


Yes, this works fine, as long as you are restoring on the same platform
(i.e. V7 single-platform restrictions still apply).

RESTORE will automatically migrate the database.
-----= Posted via Newsfeeds.Com, Uncensored Usenet News =-----
http://www.newsfeeds.com - The #1 Newsgroup Service in the World!
-----== Over 100,000 Newsgroups - 19 Different Servers! =-----
Nov 12 '05 #2
Jag wrote:
Hi all,
I am trying to see if backup taken at db2 V7.2 can be restore redirected
on V8

any one faced this problem??
regards,
jag


Not a problem : it just works (automatically upgrades your database to V8 as
part of the restore process) !!!

Phil
Nov 12 '05 #3
Yes, you can restore a v72 backup image to v8.1. The only gotya, is that
the backup must be offline, as you cannot rollforward through any log files.
"Jag" <ja**********@freddiemac.com> wrote in message
news:43**************************@posting.google.c om...
Hi all,
I am trying to see if backup taken at db2 V7.2 can be restore redirected on V8
any one faced this problem??
regards,
jag

Nov 12 '05 #4
ja**********@freddiemac.com (Jag) wrote in message news:<43**************************@posting.google. com>...
Hi all,
I am trying to see if backup taken at db2 V7.2 can be restore redirected on V8
any one faced this problem??


My test showed that to take a backup of a database in a 32-bit DB2 7.2
instance and restore it to to a DB2 8.1 32-bit instance worked fine,
as it is documented that it should; but to take a backup of a database
in 32-bit DB2 7.2 instance and restore it a DB2 8.1 64-bit instance
failed.
Nov 12 '05 #5

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

3 posts views Thread by James | last post: by
1 post views Thread by Hakim | last post: by
4 posts views Thread by Hardy | last post: by
9 posts views Thread by GL | last post: by
13 posts views Thread by Andy K | last post: by
4 posts views Thread by africantract | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.