DB2 UDB 7.2 WSE
Fixpak 9
Linux Red Hat 7.3

I will soon be upgrading my DB2 v7 database to v8, and at the same
time will be upgrading the server hardware (ie a brand new server).
What is the easiest way to do this?

Can I restore a v7 backup into a v8 install?

TIA

aj

<allenj@ndr.com> wrote in message
news:40226b33.2686915099@news.supernews.com...[color=blue]
> DB2 UDB 7.2 WSE
> Fixpak 9
> Linux Red Hat 7.3
>
> I will soon be upgrading my DB2 v7 database to v8, and at the same
> time will be upgrading the server hardware (ie a brand new server).
> What is the easiest way to do this?
>
> Can I restore a v7 backup into a v8 install?
>
> TIA
>
> aj
>[/color]
Yes, if they are both Linux (backup and restore). That would be the best
way.

On Thu, 5 Feb 2004 09:16:02 -0700, "Mark A" <ma@switchboard.net>
wrote:
[color=blue]
><allenj@ndr.com> wrote in message
>news:40226b33.2686915099@news.supernews.com...[color=green]
>> DB2 UDB 7.2 WSE
>> Fixpak 9
>> Linux Red Hat 7.3
>>
>> I will soon be upgrading my DB2 v7 database to v8, and at the same
>> time will be upgrading the server hardware (ie a brand new server).
>> What is the easiest way to do this?
>>
>> Can I restore a v7 backup into a v8 install?
>>
>> TIA
>>
>> aj
>>[/color]
>Yes, if they are both Linux (backup and restore). That would be the best
>way.[/color]

They are both Linux, but the backup will be from Red Hat 7.3 and the
restore will be onto Red Hat Advanced Server 2.1

Does this matter?

thanks

aj

<allenj@ndr.com> wrote in message
news:40226ea6.2687798509@news.supernews.com...[color=blue]
>
> They are both Linux, but the backup will be from Red Hat 7.3 and the
> restore will be onto Red Hat Advanced Server 2.1
>
> Does this matter?
>
> thanks
>
> aj
>[/color]
No problemo.

Hello Allen,

Here what would be the best approach (IMHO)

1. Do not upgrade both database and OS - if anything is wrong you'd have to rollback both changes

2. You'd need to run instance update during the migration. Make sure to review DB2 documentation on migration (check Quick Beginnings for DB2 Servers as a start)

Please, let us know if you have any additional question.

Regards,

Support
DBA Infopower
https://www.dbainfopower.com


The advice provided by DBA Infopower are provided "as is" with no warranty. DBA Infopower expressly disclaims any warranty, regarding the advice including any implied warranty of merchant fitness for a particular purpose aviating course of dealing and/or performance. DBA Infopower does not warrant that the advices provided by DBA Infopower will be free from bias, detests, errors, eavesdropping or listening. DBA Infopower shall not be responsible for the quality of information or the authentication of the services or details given by experts on the advice. By using this advice the user of the advice accepts the terms and conditions of this statement.

<allenj@ndr.com> wrote in message news:40226b33.2686915099@news.supernews.com...[color=blue]
> DB2 UDB 7.2 WSE
> Fixpak 9
> Linux Red Hat 7.3
>
> I will soon be upgrading my DB2 v7 database to v8, and at the same
> time will be upgrading the server hardware (ie a brand new server).
> What is the easiest way to do this?
>
> Can I restore a v7 backup into a v8 install?
>
> TIA
>
> aj
>
>[/color]

Just make sure your Linux distribution is listed at: http://www-306.ibm.com/software/data...inux/validate/

--

Bob
Engagement Specialist - IBM Software Services for Data Management
IBM Toronto Lab
[My comments are solely my own and are not meant to represent an official IBM position - ask my cat!]
"Mark A" <ma@switchboard.net> wrote in message news:I5uUb.52$Ki4.29442@news.uswest.net...
<allenj@ndr.com> wrote in message
news:40226ea6.2687798509@news.supernews.com...[color=blue]
>
> They are both Linux, but the backup will be from Red Hat 7.3 and the
> restore will be onto Red Hat Advanced Server 2.1
>
> Does this matter?
>
> thanks
>
> aj
>[/color]
No problemo.