473,322 Members | 1,188 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,322 software developers and data experts.

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 3232
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*******@2muchspam.yahoo.com> wrote in message
news:bv**********@hanover.torolab.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.sub.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 "unsupported" 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.sub.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
Hi Knut, Hi Philip,

thanks a lot for your answers. They were very helpful. U guess, we would
try, V7.1 running on Suse Enterprise 8 (though this is not supported
officially, only Enterprise 7 is) - if it fails, we'll upgrade DB2.

Thanks a lot
Ciao
Markus

Knut Stolze wrote:
Markus Enders <en****@mail.sub.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.


Nov 12 '05 #11

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

Similar topics

8
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...
0
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...
2
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...
5
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...
0
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....
15
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...
0
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?...
13
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
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...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you

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.