DB2 V8.1 on Mandrake 9.1/9.2

[Rhino]

Has anyone managed to get DB2 V8.1 to install and run on Linux Mandrake
9.1/9.2?

I know that IBM does not officially support DB2 on Mandrake but I also know
that the clever people who buy DB2 sometimes find a way to do things that
aren't supported. Unfortunately, I'm not that clever, especially about
installing things. The last time I tried to install DB2 V8.1 on Mandrake, I
hit a roadblock that I wasn't able to overcome. There were apparent
permissions issues when trying to create the first DB2 instance via db2icrt
but I was unable to overcome them even by lowering msec and then turning it
off entirely.

Now that it's a year later and there is lots more experience with DB2 V8.1,
I would like to give it another try but only if I get some good news that
others have actually managed to install V8.1 on Mandrake 9.1/9.2. If you
have managed to do this, I would dearly love to know what you did to get
around the problems with the instance creation - and any other predictable
problems that I never got to.

I posted this same question to a very active Mandrake newsgroup yesterday
but no one has replied to it so I thought I'd try here now.

--
Rhino
---
rhino1 AT sympatico DOT ca
"There are two ways of constructing a software design. One way is to make it
so simple that there are obviously no deficiencies. And the other way is to
make it so complicated that there are no obvious deficiencies." - C.A.R.
Hoare

[Blair Adamache]

I don't think DB2 officially supports Mandrake:

http://www-306.ibm.com/software/data...inux/validate/

Rhino wrote:

Has anyone managed to get DB2 V8.1 to install and run on Linux Mandrake
9.1/9.2?

I know that IBM does not officially support DB2 on Mandrake but I also know
that the clever people who buy DB2 sometimes find a way to do things that
aren't supported. Unfortunately, I'm not that clever, especially about
installing things. The last time I tried to install DB2 V8.1 on Mandrake, I
hit a roadblock that I wasn't able to overcome. There were apparent
permissions issues when trying to create the first DB2 instance via db2icrt
but I was unable to overcome them even by lowering msec and then turning it
off entirely.

Now that it's a year later and there is lots more experience with DB2 V8.1,
I would like to give it another try but only if I get some good news that
others have actually managed to install V8.1 on Mandrake 9.1/9.2. If you
have managed to do this, I would dearly love to know what you did to get
around the problems with the instance creation - and any other predictable
problems that I never got to.

I posted this same question to a very active Mandrake newsgroup yesterday
but no one has replied to it so I thought I'd try here now.

[Rhino]

Yes, I understand that - see the second sentence of my original post - I'm
just trying to find out if it works despite the lack of official support.

Rhino

"Blair Adamache" <ba*******@2muchspam.yahoo.com> wrote in message
news:c8**********@hanover.torolab.ibm.com...

I don't think DB2 officially supports Mandrake:

http://www-306.ibm.com/software/data...inux/validate/

Rhino wrote:

Has anyone managed to get DB2 V8.1 to install and run on Linux Mandrake
9.1/9.2?

I know that IBM does not officially support DB2 on Mandrake but I also know that the clever people who buy DB2 sometimes find a way to do things that aren't supported. Unfortunately, I'm not that clever, especially about
installing things. The last time I tried to install DB2 V8.1 on Mandrake, I hit a roadblock that I wasn't able to overcome. There were apparent
permissions issues when trying to create the first DB2 instance via db2icrt but I was unable to overcome them even by lowering msec and then turning it off entirely.

Now that it's a year later and there is lots more experience with DB2 V8.1, I would like to give it another try but only if I get some good news that others have actually managed to install V8.1 on Mandrake 9.1/9.2. If you
have managed to do this, I would dearly love to know what you did to get
around the problems with the instance creation - and any other predictable problems that I never got to.

I posted this same question to a very active Mandrake newsgroup yesterday but no one has replied to it so I thought I'd try here now.

[Todd Huish]

DB2 definitly does not support using Mandrake and they get quite upset if
you have a problem and call tech support with a problem on it, however, I
have used Mandrake 9.1/9.2/10.0 as my workstation with DB2 and it installs
just fine. I have installed both the PE and tested the WSE.

Todd Huish

On Fri, 21 May 2004 11:04:49 -0400, Rhino <rh****@NOSPAM.sympatico.ca>
wrote:

Yes, I understand that - see the second sentence of my original post -
I'm
just trying to find out if it works despite the lack of official support.

Rhino

"Blair Adamache" <ba*******@2muchspam.yahoo.com> wrote in message
news:c8**********@hanover.torolab.ibm.com...

I don't think DB2 officially supports Mandrake:

http://www-306.ibm.com/software/data...inux/validate/

Rhino wrote:

> Has anyone managed to get DB2 V8.1 to install and run on Linux

Mandrake

> 9.1/9.2?
>
> I know that IBM does not officially support DB2 on Mandrake but I also know > that the clever people who buy DB2 sometimes find a way to do things that > aren't supported. Unfortunately, I'm not that clever, especially about
> installing things. The last time I tried to install DB2 V8.1 on Mandrake, I > hit a roadblock that I wasn't able to overcome. There were apparent
> permissions issues when trying to create the first DB2 instance via db2icrt > but I was unable to overcome them even by lowering msec and then

turning

it

> off entirely.
>
> Now that it's a year later and there is lots more experience with DB2 V8.1, > I would like to give it another try but only if I get some good news that > others have actually managed to install V8.1 on Mandrake 9.1/9.2. If

you

> have managed to do this, I would dearly love to know what you did to

get

> around the problems with the instance creation - and any other predictable > problems that I never got to.
>
> I posted this same question to a very active Mandrake newsgroup yesterday > but no one has replied to it so I thought I'd try here now.
>

--
Todd Huish

[Todd Huish]

I missed some information in that last post. As root I do the following
after installing the RPMs.
# for i in dasgrp1 db2grp1 db2fgrp1 ; do groupadd $i ; done
# useradd -g dasgrp1 -m dasusr1
# useradd -g db2grp1 -m db2inst1
# useradd -g db2fgrp1 -m db2fenc1

Create the admin server and instance:

# /opt/IBM/db2/V8.1/instance/dascrt -u dasusr1
# /opt/IBM/db2/V8.1/instance/db2icrt -u db2fenc1 db2inst1

Change the password for the 3 users you just created:

# passwd dasusr1
# passwd db2inst1
# passwd db2fenc1
Todd Huish

On Fri, 21 May 2004 11:04:49 -0400, Rhino <rh****@NOSPAM.sympatico.ca>
wrote:

Yes, I understand that - see the second sentence of my original post -
I'm
just trying to find out if it works despite the lack of official support.

Rhino

"Blair Adamache" <ba*******@2muchspam.yahoo.com> wrote in message
news:c8**********@hanover.torolab.ibm.com...

I don't think DB2 officially supports Mandrake:

http://www-306.ibm.com/software/data...inux/validate/

Rhino wrote:

> Has anyone managed to get DB2 V8.1 to install and run on Linux

Mandrake

> 9.1/9.2?
>
> I know that IBM does not officially support DB2 on Mandrake but I also know > that the clever people who buy DB2 sometimes find a way to do things that > aren't supported. Unfortunately, I'm not that clever, especially about
> installing things. The last time I tried to install DB2 V8.1 on Mandrake, I > hit a roadblock that I wasn't able to overcome. There were apparent
> permissions issues when trying to create the first DB2 instance via db2icrt > but I was unable to overcome them even by lowering msec and then

turning

it

> off entirely.
>
> Now that it's a year later and there is lots more experience with DB2 V8.1, > I would like to give it another try but only if I get some good news that > others have actually managed to install V8.1 on Mandrake 9.1/9.2. If

you

> have managed to do this, I would dearly love to know what you did to

get

> around the problems with the instance creation - and any other predictable > problems that I never got to.
>
> I posted this same question to a very active Mandrake newsgroup yesterday > but no one has replied to it so I thought I'd try here now.
>

--
Todd Huish

[Rhino]

"Todd Huish" <to********@nohighvoumeemaildeployment.thesellings ource.com>
wrote in message news:op**************@ds03.tss...

I missed some information in that last post. As root I do the following
after installing the RPMs.
# for i in dasgrp1 db2grp1 db2fgrp1 ; do groupadd $i ; done
# useradd -g dasgrp1 -m dasusr1
# useradd -g db2grp1 -m db2inst1
# useradd -g db2fgrp1 -m db2fenc1

Create the admin server and instance:

# /opt/IBM/db2/V8.1/instance/dascrt -u dasusr1
# /opt/IBM/db2/V8.1/instance/db2icrt -u db2fenc1 db2inst1

Change the password for the 3 users you just created:

# passwd dasusr1
# passwd db2inst1
# passwd db2fenc1

Excellent! That's exactly the sort of information I was looking for!

Did you install the try-and-buy RPM of DB2 from the Mandrake disks or did
you install DB2 from the IBM website? I'm not sure if it makes a difference
but I suspect it does since the Mandrake RPMs seem rather different than the
ones supplied by other vendors (if MySQL is any indication).

We'd really like to put on the free Personal Edition or Personal Developers
Edition that already comes with a permanent licence since this is only a
development machine. Then, when we have all our applications written, we can
get the appropriate licence for our production machine.

Am I right in understanding that you installed DB2 with the urpm command as
normal for mandrake, then made the modifications you've listed above? In
other words, you didn't use the normal install script for DB2?

Also, did you have to do anything about msec during the install? Our msec is
normally set to the second highest setting.

Rhino

[Philip Nelson]

Rhino,

Actually I found that Mandrake 9.2 was one of the easier installs of DB2 on
"unsupported" platforms. The "db2setup" graphical installer worked just
fine, unlike on RH9 and SuSE 9. Of course you need to log on graphically
as root (or use a tool such as sux to set up the X environment) to enable
you to run this installer.

If you want to try anything esoteric, you'll find an article I wrote on
installing DB2 semi-manually in IDUG Solutions Journal (March 2003),
available online at www.idug.org.

I've even managed to get DB2 up and running successfully on Debian Sid
(which isn't even RPM based).

Personally I'm waiting for my SuSE 9.1 disks to arrive and then I'll be
replacing Stinger TP-02 (private beta) with the public beta of DB2.
Stinger seems to be a lot easier to install on newer Linux platforms in
general : I'm hoping this extends to the public beta.

Phil

Rhino wrote:

"Todd Huish" <to********@nohighvoumeemaildeployment.thesellings ource.com>
wrote in message news:op**************@ds03.tss...

I missed some information in that last post. As root I do the following
after installing the RPMs.
# for i in dasgrp1 db2grp1 db2fgrp1 ; do groupadd $i ; done
# useradd -g dasgrp1 -m dasusr1
# useradd -g db2grp1 -m db2inst1
# useradd -g db2fgrp1 -m db2fenc1

Create the admin server and instance:

# /opt/IBM/db2/V8.1/instance/dascrt -u dasusr1
# /opt/IBM/db2/V8.1/instance/db2icrt -u db2fenc1 db2inst1

Change the password for the 3 users you just created:

# passwd dasusr1
# passwd db2inst1
# passwd db2fenc1

Excellent! That's exactly the sort of information I was looking for!

Did you install the try-and-buy RPM of DB2 from the Mandrake disks or did
you install DB2 from the IBM website? I'm not sure if it makes a
difference but I suspect it does since the Mandrake RPMs seem rather
different than the ones supplied by other vendors (if MySQL is any
indication).

We'd really like to put on the free Personal Edition or Personal
Developers Edition that already comes with a permanent licence since this
is only a development machine. Then, when we have all our applications
written, we can get the appropriate licence for our production machine.

Am I right in understanding that you installed DB2 with the urpm command
as normal for mandrake, then made the modifications you've listed above?
In other words, you didn't use the normal install script for DB2?

Also, did you have to do anything about msec during the install? Our msec
is normally set to the second highest setting.

Rhino

[Rhino]

"Philip Nelson" <te*****@scotdb.com> wrote in message
news:pq***********************@news.easynews.com.. .

Rhino,

Actually I found that Mandrake 9.2 was one of the easier installs of DB2 on "unsupported" platforms. The "db2setup" graphical installer worked just
fine, unlike on RH9 and SuSE 9. Of course you need to log on graphically
as root (or use a tool such as sux to set up the X environment) to enable
you to run this installer.
Well, like I said in my original post, I'm not very good at installing
things. Whenever I come to a point where I have to choose a value for a
configuration option, it's never very obvious to me what should be chosen.
In spring 2003, I tried installing DB2 V8.1 on Mandrake 9.0 several times
but could never get past a problem in the instance creation. It seemed to be
a permissions problem but even lowering msec and then disabling altogether
didn't resolve the problem so I finally gave up.

I'm wondering what you did differently that enabled you to have an easy
install. You say that I need to log on "graphically" to use the 'db2setup'
installer. I'm not sure what you mean by that: are you saying that I have to
install from the Mandrake desktop rather than from a command prompt? If
that's what you mean, what do I click on the desktop to launch the install
if DB2 isn't installed yet? I'm not really fluent with Linux yet,
particularly the Linux GUI, but we have a desktop installed. (It contains
KDE, Konquerer, and a bunch of other programs in case the particular GUI
makes a difference.)
If you want to try anything esoteric, you'll find an article I wrote on
installing DB2 semi-manually in IDUG Solutions Journal (March 2003),
available online at www.idug.org.
Thanks for the link. I read your article. I'm now inclined to try doing
"db2_install" from the command prompt (or "console" in Linux-speak ;-) since
we want to do a standard install in English. I expect that we'll try these
instructions and then email if we run into any snags.

However, before making that attempt, I'd like to confirm that you are
talking about installing a copy of DB2 that was downloaded from the IBM
website, not one of the DB2 RPMs found on the Mandrake disks. We have the
"standard" Mandrake set, not the "pro" set that has DB2 on it.
Personally I'm waiting for my SuSE 9.1 disks to arrive and then I'll be
replacing Stinger TP-02 (private beta) with the public beta of DB2.
Stinger seems to be a lot easier to install on newer Linux platforms in
general : I'm hoping this extends to the public beta.
Just out of curiousity, what is "Stinger"? Is that the code name for DB2 V9?
What is new and different in V9? I haven't seen any information on that yet.

Rhino

Rhino wrote:

"Todd Huish" <to********@nohighvoumeemaildeployment.thesellings ource.com> wrote in message news:op**************@ds03.tss...

I missed some information in that last post. As root I do the following
after installing the RPMs.
# for i in dasgrp1 db2grp1 db2fgrp1 ; do groupadd $i ; done
# useradd -g dasgrp1 -m dasusr1
# useradd -g db2grp1 -m db2inst1
# useradd -g db2fgrp1 -m db2fenc1

Create the admin server and instance:

# /opt/IBM/db2/V8.1/instance/dascrt -u dasusr1
# /opt/IBM/db2/V8.1/instance/db2icrt -u db2fenc1 db2inst1

Change the password for the 3 users you just created:

# passwd dasusr1
# passwd db2inst1
# passwd db2fenc1

Excellent! That's exactly the sort of information I was looking for!

Did you install the try-and-buy RPM of DB2 from the Mandrake disks or did you install DB2 from the IBM website? I'm not sure if it makes a
difference but I suspect it does since the Mandrake RPMs seem rather
different than the ones supplied by other vendors (if MySQL is any
indication).

We'd really like to put on the free Personal Edition or Personal
Developers Edition that already comes with a permanent licence since this is only a development machine. Then, when we have all our applications
written, we can get the appropriate licence for our production machine.

Am I right in understanding that you installed DB2 with the urpm command
as normal for mandrake, then made the modifications you've listed above?
In other words, you didn't use the normal install script for DB2?

Also, did you have to do anything about msec during the install? Our msec is normally set to the second highest setting.

Rhino

[Todd Huish]

I am using the IBM downloaded edition of DB2 and used the DB2 installer as
well. I looked at latching urpmi on to it and installing it that way but
it didn't seem to have any benefit since urpmi just does rpm in the
background anyway which is all the install script does. In the beginning
the DB2 install was really touchy in the first place and I didnt want to
play with it any more than necessary so I tried to mold my habits to fit
IBM instead of the other way around. The real joy was getting it to work
on Gentoo machines which don't even have rpm installed. I did not have to
mess with msec but I install my workstation at the standard level instead
of the higher levels. Every time I install mandrake with a higher msec
level it just ticks me off by being difficult and I give up and kick it
back to standard.

Todd Huish

On Fri, 21 May 2004 17:53:35 -0400, Rhino <rh****@NOSPAM.sympatico.ca>
wrote:

Excellent! That's exactly the sort of information I was looking for!

Did you install the try-and-buy RPM of DB2 from the Mandrake disks or did
you install DB2 from the IBM website? I'm not sure if it makes a
difference
but I suspect it does since the Mandrake RPMs seem rather different than
the
ones supplied by other vendors (if MySQL is any indication).

We'd really like to put on the free Personal Edition or Personal
Developers
Edition that already comes with a permanent licence since this is only a
development machine. Then, when we have all our applications written, we
can
get the appropriate licence for our production machine.

Am I right in understanding that you installed DB2 with the urpm command
as
normal for mandrake, then made the modifications you've listed above? In
other words, you didn't use the normal install script for DB2?

Also, did you have to do anything about msec during the install? Our
msec is
normally set to the second highest setting.

Rhino

[Todd Huish]

I have found that I detest Java and IBM's reliance on it. I was going
crazy until I found out that you could install it from the CLI with
db2_install. It was installing DB2 runtime clients over a T1 with a remote
X session that finally made me crack. Now I can install it on remote
machines and servers painlessly. Now if I could find a replacement for
db2cc I could die happy.

Todd

On Mon, 24 May 2004 09:53:42 -0400, Rhino <rh****@NOSPAM.sympatico.ca>
wrote:

"Philip Nelson" <te*****@scotdb.com> wrote in message
news:pq***********************@news.easynews.com.. .

Rhino,

Actually I found that Mandrake 9.2 was one of the easier installs of DB2

on

"unsupported" platforms. The "db2setup" graphical installer worked
just
fine, unlike on RH9 and SuSE 9. Of course you need to log on
graphically
as root (or use a tool such as sux to set up the X environment) to
enable
you to run this installer.

Well, like I said in my original post, I'm not very good at installing
things. Whenever I come to a point where I have to choose a value for a
configuration option, it's never very obvious to me what should be
chosen.
In spring 2003, I tried installing DB2 V8.1 on Mandrake 9.0 several times
but could never get past a problem in the instance creation. It seemed
to be
a permissions problem but even lowering msec and then disabling
altogether
didn't resolve the problem so I finally gave up.

[Mark A]

"Todd Huish" <to********@nohighvoumeemaildeployment.thesellings ource.com>
wrote in message news:op**************@ds03.tss...

I have found that I detest Java and IBM's reliance on it. I was going
crazy until I found out that you could install it from the CLI with
db2_install. It was installing DB2 runtime clients over a T1 with a remote
X session that finally made me crack. Now I can install it on remote
machines and servers painlessly. Now if I could find a replacement for
db2cc I could die happy.

Todd

Take a look at Quest Central for DB2. There is a freeware version with some
functions disabled available for download.
http://www.quest.com/quest_central/