"Kelly D. Rodger" <krodger@ca.ibm.com> wrote in message news:<bd7tce$65e$1@hanover.torolab.ibm.com>...
> Michael Bhola wrote:
> > "Brice Avila" <briceavila@hotmail.com> wrote in message
> > news:c46e3ec5.0306230559.7c8662e4@posting.google.c om...
> >
> >>Second, I know that one can backup and restore a DB2 instance over big
> >>endian Unix platforms (i.e. AIX to Solaris or HP-UX) but what about
> >>versions?
> >
> >
> > Actually I don't think this is correct. I believe there is only compatibiliy
> > between Solaris and HP-UX at V7.
>
> 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

Hi Kelly,

I understand that under AIX 4.3.3 I can migrate DB2/UDB 5.2 to DB2/UDB
7
Does it mean I can restore (re-directed) DB2/UDB 5.2 backup created on
AIX 4.3.3 on to a new server with AIX 4.3.3 & DB2/UDB 7 ?

If I can do that, it will help me to migrate DB2/UDB 5.2 to DB2/UDB 7
on new server.

Is there any effect due to data dictonary changes between these
releases ?

Real iceing on cake would be, if I could restore (re-directed) DB2/UDB
7 under AIX 4.3.3 backup on to another server with DB2/UDB 5.2 under
AIX 4.3.3 !!

Thanks,

VKG