DB2 PE and Debian GNU/Linux

[Alexander Nofftz]

Hi!

I am unsuccessfully trying to get DB2 working under Debian GNU/Linux
Unstable for some weeks now.

The setup wizard of db2setup allways freezes. I have waited for a whole
hour, but nothing happend.

So I tryed to install DB2 using db_install, but this only decompresses the
RPM files, no more.
In the meantime I found this instructions:

http://salz.is.informatik.uni-duisbu...t/t0007067.htm

I've manually created the groups and users and after that I created an
instance using this command:

db2icrt -u db2fenc1 db2inst1

This seems to work. Even a directory ~/sqllib containing the most
important DB2 commands has been created. However calling db2start allways
brings up this error:

SQL1042C Unerwarteter Systemfehler. SQLSTATE=58004

Can somebody tell me what I have done wrong?

Thanks in advance,
Alex

--
Alexander Nofftz, Leverkusen, Germany
al********@email.com
http://www.alexnofftz.de/

[Philip Nelson]

Alexander Nofftz wrote:

Hi!

I am unsuccessfully trying to get DB2 working under Debian GNU/Linux
Unstable for some weeks now.

The setup wizard of db2setup allways freezes. I have waited for a whole
hour, but nothing happend.

So I tryed to install DB2 using db_install, but this only decompresses the
RPM files, no more.
In the meantime I found this instructions:

http://salz.is.informatik.uni-duisbu...t/t0007067.htm

I've manually created the groups and users and after that I created an
instance using this command:

db2icrt -u db2fenc1 db2inst1

This seems to work. Even a directory ~/sqllib containing the most
important DB2 commands has been created. However calling db2start allways
brings up this error:

SQL1042C Unerwarteter Systemfehler. SQLSTATE=58004

Can somebody tell me what I have done wrong?

Thanks in advance,
Alex

Alex,

You may want to look at the article I wrote for IDUG Solutions Journal a
while ago. I had DB2 V8 up and running quite happily on Debian for quite
some time (before having to go to RPM based distros for other reasons).

Here's the link -

http://www.idug.org/idug/member/jour.../article04.cfm

HTH

Phil

[Alexander Nofftz]

Hi Philip!

Am Mon, 07 Jun 2004 22:49:07 +0000 schrieb Philip Nelson:

You may want to look at the article I wrote for IDUG Solutions Journal a
while ago. I had DB2 V8 up and running quite happily on Debian for quite
some time (before having to go to RPM based distros for other reasons).

Here's the link -

http://www.idug.org/idug/member/jour.../article04.cfm

Thanks for this, but I also doesn't work.

However I used db2trc on and this gives me this error:

$ db2trc on
Trace is turned on
$ db2start
/home/db2inst1/sqllib/adm/db2star2: relocation error:
/home/db2inst1/sqllib/adm/db2star2: undefined symbol:
sqloInitIPCWaitPost

Thanks in advance,
Alex

--
Alexander Nofftz, Leverkusen, Germany
al********@email.com
http://www.alexnofftz.de/

[Philip Nelson]

Alexander Nofftz wrote:

Hi Philip!

Am Mon, 07 Jun 2004 22:49:07 +0000 schrieb Philip Nelson:

You may want to look at the article I wrote for IDUG Solutions Journal a
while ago. I had DB2 V8 up and running quite happily on Debian for
quite some time (before having to go to RPM based distros for other
reasons).

Here's the link -

http://www.idug.org/idug/member/jour.../article04.cfm

Thanks for this, but I also doesn't work.

However I used db2trc on and this gives me this error:

$ db2trc on
Trace is turned on
$ db2start
/home/db2inst1/sqllib/adm/db2star2: relocation error:
/home/db2inst1/sqllib/adm/db2star2: undefined symbol:
sqloInitIPCWaitPost

Thanks in advance,
Alex

Alex,

Sounds like you are not finding the DB2 libraries. Is the DB2 library
directory linked to or in your library path. I have the following
environment variables set by the (Stinger) installer -

LD_LIBRARY_PATH=:/home/db2inst1/sqllib/lib
LIBPATH=:/home/db2inst1/sqllib/lib

There's nothing relating to DB2 in ld.so.conf and I don't think there are
soft links either.

The setting up of these paths is done by adding the db2profile script to
your .bash_profile. Here's the line to add -

.. /home/db2inst1/sqllib/db2profile

Try adding this and let me know how you get on.

If that doesn't work, can you tell me what kernel you are running ?

Phil

[Alexander Nofftz]

Hi!

Am Tue, 08 Jun 2004 12:25:26 +0000 schrieb Philip Nelson:

Sounds like you are not finding the DB2 libraries. Is the DB2 library
directory linked to or in your library path. I have the following
environment variables set by the (Stinger) installer -

LD_LIBRARY_PATH=:/home/db2inst1/sqllib/lib
LIBPATH=:/home/db2inst1/sqllib/lib
Yeah, that's all ok.
If that doesn't work, can you tell me what kernel you are running ?

I'm running Linux 2.6.6 here. Is 2.6 a problem?
I'll try it out using Knoppix...

Regards,
Alex

[Alexander Nofftz]

Am Wed, 09 Jun 2004 00:04:45 +0200 schrieb Alexander Nofftz:

I'm running Linux 2.6.6 here. Is 2.6 a problem?
I'll try it out using Knoppix...

Kernel 2.4.21 also doesn't work.

However, I noticed this:

$ ldd -r sqllib/adm/db2star2
libdb2e.so.1 => /opt/IBM/db2/V8.1/lib/libdb2e.so.1 (0x40019000)
libdb2g11n.so.1 => /opt/IBM/db2/V8.1/lib/libdb2g11n.so.1 (0x43171000)
libdb2osse.so.1 => /opt/IBM/db2/V8.1/lib/libdb2osse.so.1 (0x431e3000)
libm.so.6 => /lib/tls/libm.so.6 (0x43284000)
libcxa.so.1 => /opt/IBM/db2/V8.1/lib/libcxa.so.1 (0x432a7000)
libc.so.6 => /lib/tls/libc.so.6 (0x43315000)
libcrypt.so.1 => /lib/tls/libcrypt.so.1 (0x43451000)
libdl.so.2 => /lib/tls/libdl.so.2 (0x4347d000)
libpthread.so.0 => /lib/tls/libpthread.so.0 (0x43480000)
librt.so.1 => /lib/tls/librt.so.1 (0x4348f000)
libdb2install.so.1 => /opt/IBM/db2/V8.1/lib/libdb2install.so.1 (0x43495000)
libdb2locale.so.1 => /opt/IBM/db2/V8.1/lib/libdb2locale.so.1 (0x43499000)
libdb2genreg.so.1 => /opt/IBM/db2/V8.1/lib/libdb2genreg.so.1 (0x434b7000)
libdb2trcapi.so.1 => /opt/IBM/db2/V8.1/lib/libdb2trcapi.so.1 (0x43500000)
/lib/ld-linux.so.2 => /lib/ld-linux.so.2 (0x40000000)
undefined symbol: sqloWaitIPCWaitPost (sqllib/adm/db2star2)
undefined symbol: sqloTermIPCWaitPost (sqllib/adm/db2star2)
undefined symbol: _Z16sqleInitEventLogv (sqllib/adm/db2star2)
undefined symbol: sqloInitIPCWaitPost (sqllib/adm/db2star2)
undefined symbol: sqloResetIPCWaitPost (sqllib/adm/db2star2)

So it seems that an important library is missing, but I don't know which. :-(

Regards,
Alex