473,396 Members | 2,030 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,396 software developers and data experts.

Upgrade DB2 v7 -> v8 and new server h/w. Best approach?

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
Nov 12 '05 #1
5 2193
<al****@ndr.com> wrote in message
news:40*****************@news.supernews.com...
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

Yes, if they are both Linux (backup and restore). That would be the best
way.
Nov 12 '05 #2
On Thu, 5 Feb 2004 09:16:02 -0700, "Mark A" <ma@switchboard.net>
wrote:
<al****@ndr.com> wrote in message
news:40*****************@news.supernews.com...
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

Yes, if they are both Linux (backup and restore). That would be the best
way.


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
Nov 12 '05 #3
<al****@ndr.com> wrote in message
news:40*****************@news.supernews.com...

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

No problemo.
Nov 12 '05 #4

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.

<al****@ndr.com> wrote in message news:40*****************@news.supernews.com...
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

Nov 12 '05 #5
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:I5****************@news.uswest.net...
<al****@ndr.com> wrote in message
news:40*****************@news.supernews.com...

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

No problemo.
Nov 12 '05 #6

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
by: Tappy Tibbons | last post by:
Have many of you upgraded to VS 2003? We have been using Visual Studio 2002, and are somewhat satisfied, except for the following areas: Speed - VS2002 apps are dead dog slow to start up, and...
1
by: cpchan | last post by:
If I want to upgrade the following system : (1) Oracle 8i RDBMS (2) Oracle Finance 11.5.2 to : (1) Oracle 9i RDBMS (2) Oracle Finance 11.5.8
8
by: Patrick | last post by:
Hi I am in the process of learning javascript and was wondering how often the web professionals update I.E & N.N? I mean do you religiously wait for the next upgrade and download it ASAP when...
3
by: John | last post by:
Hello, I am trying to figure out how to determine if I have fixed an upgrade warning. If I delete the green text then the upgrade warning goes away. However, I would expect it to come back...
36
by: Tim | last post by:
Is there a way to upgrade from Visual C++ Net 2002 to Visual C++ Net 2003? The 2002 version does not provide a Windows Forms Designer. I can't find any upgrade package on Microsoft's website. ...
2
by: Herfried K. Wagner [MVP] | last post by:
Hello, There are often questions in this newsgroup posted by VS.NET 2002 users. VS.NET 2002 is "out of date", its successor is VS.NET 2003. There is a special ("cheap") upgrade offer available...
4
by: Linda | last post by:
I create program with VB programming and now i want that program run at VB.NET. So i open the vb project from VB.Net, while i upgrade the program ,i found Error : VB Upgrade wizard error...
2
by: Scott R | last post by:
I have purchased the VS 2005 professional upgrade. I would like to remove VS 2003 prior to installation. If I uninstall VS 2003, how does VS 2005 know I qualify for the upgrade pricing?
6
by: Ajith Menon | last post by:
I am working on a project "ABC" which needs to be upgraded from .NET framework 1.1. We are thinking about upgrading it to .NET framework 2.0. The reason for this is that we have some unmanaged...
0
by: nilart | last post by:
Hi , Our current windows application uses postgre 8.1 while next release will be using postgre 8.3 Naturally when application is upgraded ..postgre is expected to upgrade To support this...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
0
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.