473,728 Members | 1,713 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Migrating from Solaris to Linux

Hi everybody,

currently we use DB2 7.1 on several Solaris machines. Now we are
planning, to migrate to SUSE Linux (newest version).
I wonder, if we can keep our DB2 version 7.1, or if we need to upgrade
to version 8. How are your experiences running DB2 in version 7.1 on Linux.

How difficult is the migration from Solaris to Linux concerning DB2? Are
there some pitfalls or can I simply install the DB2, create my database
(tables and views) and than export the database (using db2move) on the
Solaris machine and import it under Linux (using db2move)?
Has anybody done this before?

I'm curious especially about the JDBC driver. It seems, that for
different DB2 versions, you need different JDBC drivers. Is this also
the case, when moving from one OS to the other?
If so, is it possible to use different JDBC drivers (for different
versions) in one Java/Tomcat-Instance? How?

Any answers are welcome...
Thanks & Ciao
Markus

Nov 12 '05 #1
10 3274
The JDK's are listed here under Platform Support:

http://www-306.ibm.com/software/data...db/ad/v8/java/

For you it mteans moving from a Javasoft JDK to an IBM JDK.

Markus Enders wrote:
Hi everybody,

currently we use DB2 7.1 on several Solaris machines. Now we are
planning, to migrate to SUSE Linux (newest version).
I wonder, if we can keep our DB2 version 7.1, or if we need to upgrade
to version 8. How are your experiences running DB2 in version 7.1 on Linux.

How difficult is the migration from Solaris to Linux concerning DB2? Are
there some pitfalls or can I simply install the DB2, create my database
(tables and views) and than export the database (using db2move) on the
Solaris machine and import it under Linux (using db2move)?
Has anybody done this before?

I'm curious especially about the JDBC driver. It seems, that for
different DB2 versions, you need different JDBC drivers. Is this also
the case, when moving from one OS to the other?
If so, is it possible to use different JDBC drivers (for different
versions) in one Java/Tomcat-Instance? How?

Any answers are welcome...
Thanks & Ciao
Markus


Nov 12 '05 #2
If you use db2 udb v7.x (64bit). AFAIK, there is no JVM 64bit (even IBM jvm)
on Linux.

"Blair Adamache" <ba*******@2muc hspam.yahoo.com > wrote in message
news:bv******** **@hanover.toro lab.ibm.com...
The JDK's are listed here under Platform Support:

http://www-306.ibm.com/software/data...db/ad/v8/java/

For you it mteans moving from a Javasoft JDK to an IBM JDK.

Markus Enders wrote:
Hi everybody,

currently we use DB2 7.1 on several Solaris machines. Now we are
planning, to migrate to SUSE Linux (newest version).
I wonder, if we can keep our DB2 version 7.1, or if we need to upgrade
to version 8. How are your experiences running DB2 in version 7.1 on Linux.
How difficult is the migration from Solaris to Linux concerning DB2? Are
there some pitfalls or can I simply install the DB2, create my database
(tables and views) and than export the database (using db2move) on the
Solaris machine and import it under Linux (using db2move)?
Has anybody done this before?

I'm curious especially about the JDBC driver. It seems, that for
different DB2 versions, you need different JDBC drivers. Is this also
the case, when moving from one OS to the other?
If so, is it possible to use different JDBC drivers (for different
versions) in one Java/Tomcat-Instance? How?

Any answers are welcome...
Thanks & Ciao
Markus

Nov 12 '05 #3
Hi Blair,

Blair Adamache wrote:
The JDK's are listed here under Platform Support:

http://www-306.ibm.com/software/data...db/ad/v8/java/

Thanks for posting this link - it was very interesting. But as far as I
understand it describes the current situation for DB V8. But we want to
use the older 7.1. version.
Any information about this old version?

For you it mteans moving from a Javasoft JDK to an IBM JDK.

That's very good to know.

Ciao
Markus

Markus Enders wrote:
Hi everybody,

currently we use DB2 7.1 on several Solaris machines. Now we are
planning, to migrate to SUSE Linux (newest version).
I wonder, if we can keep our DB2 version 7.1, or if we need to upgrade
to version 8. How are your experiences running DB2 in version 7.1 on
Linux.

How difficult is the migration from Solaris to Linux concerning DB2?
Are there some pitfalls or can I simply install the DB2, create my
database (tables and views) and than export the database (using
db2move) on the Solaris machine and import it under Linux (using
db2move)?
Has anybody done this before?

I'm curious especially about the JDBC driver. It seems, that for
different DB2 versions, you need different JDBC drivers. Is this also
the case, when moving from one OS to the other?
If so, is it possible to use different JDBC drivers (for different
versions) in one Java/Tomcat-Instance? How?

Any answers are welcome...
Thanks & Ciao
Markus


Nov 12 '05 #4
Markus Enders <en****@mail.su b.uni-goettingen.de> wrote:
The JDK's are listed here under Platform Support:

http://www-306.ibm.com/software/data...db/ad/v8/java/

Thanks for posting this link - it was very interesting. But as far as I
understand it describes the current situation for DB V8. But we want to
use the older 7.1. version.
Any information about this old version?


Just follow the link that is provided on the V8 site and you will get there:
http://www-306.ibm.com/software/data...d/v7/java.html

--
Knut Stolze
Information Integration
IBM Germany / University of Jena
Nov 12 '05 #5
Hi Knut,

Knut Stolze wrote:

Just follow the link that is provided on the V8 site and you will get there:
http://www-306.ibm.com/software/data...d/v7/java.html


Thanks a lot.
Do you or anybody else knows of some special hints or pitfalls when
installing the older 7.1 version of DB2 on the newest Suse Linux
Enterprise 8 version?
Or aren't there any problems (would be nice to hear ;-)?

Thanks, Ciao
Markus

Nov 12 '05 #6
On Tue, 03 Feb 2004 16:30:47 +0100, Markus Enders wrote:
Hi Knut,

Knut Stolze wrote:

Just follow the link that is provided on the V8 site and you will get there:
http://www-306.ibm.com/software/data...d/v7/java.html


Thanks a lot.
Do you or anybody else knows of some special hints or pitfalls when
installing the older 7.1 version of DB2 on the newest Suse Linux
Enterprise 8 version?
Or aren't there any problems (would be nice to hear ;-)?

Thanks, Ciao
Markus


Markus,

Some things to note about installing V7 on Linux in general -

1) Look at the DB2-HOWTO from http://www.tldp.org
2) You'll need to install package pdksh (Korn shell)
3) You'll probably need to up the MSGMNI kernel parameter (V8 does this
automatically)

All of this is explained in the docs and the HOWTO.

(suggest you
apply the latest
fixpacks to bring you up to date : you need FP3 to take you to V7.2 level
followed by the latest which I think is FP11) -

However, I'd strongly suggest you take this opportunity to move to V8, as
V7.2 has less than a couple of months of support left (expires March 31st)
and V7.1 is already not supported.

Since you are talking about an OS shift you'll need to use db2move to get
the data across (you can't restore a backup from Solaris on Linux).
Nov 12 '05 #7
On Tue, 03 Feb 2004 16:30:47 +0100, Markus Enders wrote:
Hi Knut,

Knut Stolze wrote:

Just follow the link that is provided on the V8 site and you will get there:
http://www-306.ibm.com/software/data...d/v7/java.html


Thanks a lot.
Do you or anybody else knows of some special hints or pitfalls when
installing the older 7.1 version of DB2 on the newest Suse Linux
Enterprise 8 version?
Or aren't there any problems (would be nice to hear ;-)?

Thanks, Ciao
Markus


And to finish typing what I meant to before hitting "Send" by mistake -

And to provide some cheer, my experience of DB2 on Linux has overall been
a happier one than on Solaris.

Perhaps this is because the Linux sysadmins I've worked with are more
switched on than the Solaris ones, but I don't think that is the only
reason.

My V7 Linux heavy-duty experience has been using Red Hat V7.2, but the V8
installs I'm involved in are mainly going to be SLES (SuSE Linux
Enterprise Server) V8. This is mainly due to the fact that DB2 wasn't
supported on the latest Red Hat Enterprise Server when testing V8.

I've also run V7 and V8 happily on "unsupporte d" versions of Linux such as
Mandrake and Debian, the latter being quite a challenge to get running as
it uses a different package management system. Obviously you wouldn't do
that in your production environment, but on your test laptop ...

If you need any help with DB2 on Linux don't hesitate to contact me
through my website http://www.scotdb.com

You might also want to pick up my paper (presented to IDUG Europe in
October) "DB2 on Linux : Ready for Prime Time" which is on the Downloads
page of my site.

Phil Nelson
Nov 12 '05 #8
Hi Philip,

Philip Nelson wrote:

s,

Some things to note about installing V7 on Linux in general -

1) Look at the DB2-HOWTO from http://www.tldp.org

Found it already. But I couldn't find special information which DB2
version runs under which SuSE Linux version.

2) You'll need to install package pdksh (Korn shell)

Good to know.

(suggest you
apply the latest
fixpacks to bring you up to date : you need FP3 to take you to V7.2 level
followed by the latest which I think is FP11) -

What about the client drivers (ODBC and JDBC)? We will still use the
older DB2 V71. on other Solaris systems but need to access the older and
the newer (Linux) version from the same clients.
As I understood, every new version needs its own db2 driver (can't us
V7.1 db2 ODBC driver to access DB2 V8). Can I install both drivers (JDBC
and ODBC) on the same computer (windows).
Or are there any problems?

Since you are talking about an OS shift you'll need to use db2move to get
the data across (you can't restore a backup from Solaris on Linux).

Yeah, that's something I found out already transfering data from Linux
to Windows ;-)

Thanks a lot
Ciao
Markus

Nov 12 '05 #9
Markus Enders <en****@mail.su b.uni-goettingen.de> wrote:
Some things to note about installing V7 on Linux in general -

1) Look at the DB2-HOWTO from http://www.tldp.org


Found it already. But I couldn't find special information which DB2
version runs under which SuSE Linux version.


Have a look here: http://www-306.ibm.com/software/data...inux/validate/

There is also a link on this site that leads you to the information for V7.

--
Knut Stolze
Information Integration
IBM Germany / University of Jena
Nov 12 '05 #10

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

Similar topics

8
3004
by: Xela | last post by:
Hi A have a very annoying problem. I have written java strored procedures for DB2 v8.1. Their deployement and usage is fine as long as the server is a Windows one. But under Solaris 8 and Linux RH, the call of sqlj.install_jar fails. It correctly create a directiory with the correct schema name, but the jar is not copied in it. The error is "Permission Denied" SQLSTATE 38501 and in the log, we can see that calling sqlejReadJar fails in...
0
4545
by: Zorba.GR | last post by:
IBM DB2 Connect Enterprise Edition v8.2, other IBM DB2 (32 bit, 64 bit) (MULTiOS, Windows, Linux, Solaris), IBM iSoft Commerce Suite Server Enterprise v3.2.01, IBM Tivoli Storage Resource Manager Express Edition v1.3.2 Win, IBM Tivoli System Automation v1.2.0 Linux, IBM Tivoli Workload Scheduler Virtualized Data Centers v8.2 , other IBM Tivoli CDs, WEBSPHERE EVERYPLACE MOBILE PORTAL v5.0 - ALTIUM , other IBM WebSphere Business CDs...
2
2457
by: Cam Chapman | last post by:
Does anyone have any experience migrating a DB2 database off UDB 6.1 (Solaris) to 7.2 (Linux)? The database does not already exist on the Linux box. Have created a DB2 instance fine. DB2 installation went ok (no fixpacks installed yet though!) and can create sample database and query. In my naiivity as a non dba reformed developer, I've dumped the database on the solaris box and am trying to perform a restore on the Linux box using the...
5
1496
by: Dave | last post by:
Compiled using g++ on linux and then I tried to execute it on Solaris. The error message was something like "can't execute a.out" - works ok on linux - ran chmod so Sun user has execute/read/etc permissions. chmod u=rwx Any clues why? I am new to the non windows world. Thanks
0
9743
by: Kirt Loki Dankmyer | last post by:
So, I download the latest "stable" tar for perl (5.8.7) and try to compile it on the Solaris 8 (SPARC) box that I administrate. I try all sorts of different switches, but I can't get it to compile. I need it to be compiled with threads. Anyone have any wisdom on how best to do this? Here's a transcript of my latest attempt. It's long; you might want to skip to the bottom, where I try "make" and the fatal errors start happening.
15
2465
by: Joe Weinstein | last post by:
Hi. Below is a simple JDBC program to insert and extract a numerical value. When ResultSet.getDouble() is called, the same program produces different output on solaris than it does on Linux. I would be grateful for any discussion of this! thanks, Joe Weinstein at BEA Systems Results on Linux Box -----------------------------------------------------------------------
0
1394
by: AnonymousFC4 | last post by:
1) Debugger. Is gdb (or ddd) still the best tool to debug C++ prog a) on Linux? b) On Solaris? 2) IDE, can you debug C++ programms, using Eclipse-cdt on both Linux and Solaris? Other tools? Thanks.
13
4091
by: Mary Lei | last post by:
Does anyone know the link to obtain the tarball for db2 8.1 for solaris running on AMD 64 bit ? This is the entire db2 installation on a new system that does not have db2. Thanks.
4
2667
by: tkirankumar | last post by:
Hi all, This is regarding the issue I am facing while porting the my application from SuSe Linux to Sun Solaris. The Existing system details: Itanium boxes 1mhz 4 processor 8 gb machines with SuSe Linux $ uname -a Linux longrtedged01 2.4.21-215-itanium2-smp #1 SMP Mon Apr 26 16:28:29
0
8755
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 effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
9267
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 tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
0
9125
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 protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
0
8117
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, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
0
4523
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
0
4787
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
3231
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
2
2645
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
3
2159
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

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.