Programming Zen

Installing DB2 9.5 on Ubuntu 7.10

Antonio Cangiano

The official IBM site now has DB2 Express-C 9.5 available for download. Like its previous versions it’s entirely free, so why don’t you give it a try?

When running db2setup, after extracting the archive you downloaded, you may be disappointed to see that on Ubuntu 7.10 the setup program gives you the following error right out of the box:

ERROR:
 The required library file libstdc++.so.5 is not found on the system.
ERROR:
 The required library file libaio.so.1 is not found on the system.
 Check the following web site for the up-to-date system requirements
 of IBM DB2 9.5
 https://www.ibm.com/software/data/db2/udb/sysreqs.html
 https://www.software.ibm.com/data/db2/linux/validate
/home/antonio/Desktop/exp/db2/linux/install/../bin/db2usrinf:
error while loading shared libraries: libstdc++.so.5:
cannot open shared object file: No such file or directory
[: 609: 0: unexpected operator
/home/antonio/Desktop/exp/db2/linux/install/../bin/db2langdir:
error while loading shared libraries: libstdc++.so.5:
cannot open shared object file: No such file or directory
/home/antonio/Desktop/exp/db2/linux/install/../bin/db2langdir:
error while loading shared libraries: libstdc++.so.5:
cannot open shared object file: No such file or directory
DBI1055E The message file db2install.cat cannot be found.

Explanation:  The message file required by this
script is missing from the system; it may have been
deleted or the database products may have been loaded
incorrectly.

User Response:  Verify that the product option containing
the message file is installed correctly.  If there are
verification errors; reinstall the product option.

Here is a handy tip, just in case you get stuck with this error. You can install the prerequisites and run the DB2 setup program simply by executing the three commands below (in order).

sudo apt-get install libstdc++5
sudo apt-get install libaio-dev
sudo ./db2setup

I hope this quick tip saves you some time and a headache.

Antonio Cangiano

Antonio Cangiano is an Engineering Manager and AI Specialist at IBM. He authored Ruby on Rails for Microsoft Developers (Wrox, 2009) and Technical Blogging (The Pragmatic Bookshelf, 2012, 2019). He is also the Marketing Lead for Cognitive Class, an educational initiative which he helped grow from zero to over 3 Million students. You can follow him on Twitter.

16 responses to “Installing DB2 9.5 on Ubuntu 7.10”

  1. Nicola Larosa

    > Like its previous versions it’s entirely free,
    > so why don’t you give it a try?

    Because it’s not Free. Sorry pal.

    Besides, this blog has that “R*by” word in the title, yech. ;-P

  2. brad clements

    If you’re using 64-bit Gutsy, and try to install the local version of info center, you will also be interested in this thread:

    http://www-128.ibm.com/developerworks/forums/thread.jspa?threadID=182136&tstart=0

    I am looking forward to Python sqlalchemy support! Thanks

  3. Antonio Cangiano

    > Because it’s not Free.

    Eheh. It’s not Free in the open source sense, but it’s entirely free (notice the lower case f) of charge. As strange as it may sound, the fact that it’s not open source simplifies the adoption of the database system a lot within large companies, who usually require lengthy processes and legal approvals by internal committees before they allow for user contributed software. As much as I like open source myself, DB2 not being open source has advantages within our (admittedly flawed) industry and anyone who works for a big company should already be aware of this.

    > Besides, this blog has that “R*by” word in the title, yech. ;-P

    It could be worse, it could have been Pyth*n. 😛

  4. Pythian Group Blog » Blog Archive » Log Buffer #71: a Carnival of the Vanities for DBAs

    […] While we’re on the business of installs, on Zen and the Art of Ruby Programming, Antonio Cangiano has a workaround to a problem with installing DB2 9.5 on Ubuntu 7.10. […]

  5. David Cesarano

    After doing this I noticed that you can only do a NON-ROOT install for Ubuntu, since there is no root user. If your playing around with DB2 I think this is just fine, but it is not something used in large companies. I would suggest using Red Hat or Suse if you want to learn and play with a Unix based DB2.

  6. kaare

    thanks for the posting – will definitely save me some time :-). I run db2 on redhat, suse etc. but develop on ubuntu with local installs of db2.

  7. Morten

    If the setup window is completely grey, without any widgets, then try to disable the visual effects under Ubuntu.

    System -> Appearance -> Visual Effects -> None.

  8. scampbell

    No root user in ubuntu?? uhhh sure there is…and I just did a root install. Obviously David Cesarno doesnt know what he is talking about and should probably detach his keyboard from the internetz. Thanks for this thread although im pretty sure all but complete newbs will know how to resolve a simple dependency problem like this.

  9. rohith

    Please be connected to the internet while installing the library files

  10. Gigi

    I’ve had the same problem trying to install a .bin package from sun.
    After installing libc5 the package hangs with
    *** glibc detected *** ./sjsas-9_1_02-linux.bin: free(): invalid next size (normal): 0x08073050 ***
    ======= Backtrace: =========
    /root/../lib/tls/i686/cmov/libc.so.6[0xb7d85a85]
    /root/../lib/tls/i686/cmov/libc.so.6(cfree+0x90)[0xb7d894f0]
    ./sjsas-9_1_02-linux.bin(zcfree+0x1e)[0x8056be2]
    ./sjsas-9_1_02-linux.bin(inflate_trees_bits+0xb7)[0x805a53b]
    ./sjsas-9_1_02-linux.bin(inflate_blocks+0xc27)[0x8057a5e]
    ./sjsas-9_1_02-linux.bin(inflate+0x3a7)[0x80563fe]
    ./sjsas-9_1_02-linux.bin[0x8051909]
    ./sjsas-9_1_02-linux.bin(zipReadEntry+0x13b)[0x8051b64]
    ./sjsas-9_1_02-linux.bin(UnzipFiles+0x1b9)[0x804fdd3]
    ./sjsas-9_1_02-linux.bin(main+0xa3e)[0x804e4c2]
    /root/../lib/tls/i686/cmov/libc.so.6(__libc_start_main+0xe0)[0xb7d30450]
    ./sjsas-9_1_02-linux.bin(dlopen+0x41)[0x804c9f5]
    ======= Memory map: ========
    08048000-08061000 r-xp 00000000 08:02 14139509 /root/sjsas-9_1_02-linux.bin
    08061000-08063000 rw-p 00018000 08:02 14139509 /root/sjsas-9_1_02-linux.bin
    08063000-08084000 rw-p 08063000 00:00 0 [heap]
    b7a00000-b7a21000 rw-p b7a00000 00:00 0
    b7a21000-b7b00000 —p b7a21000 00:00 0
    b7bf5000-b7bf6000 rw-p b7bf5000 00:00 0
    b7bf6000-b7c35000 r–p 00000000 08:02 6374244 /usr/lib/locale/it_IT.utf8/LC_CTYPE
    b7c35000-b7c36000 r–p 00000000 08:02 6374315 /usr/lib/locale/it_IT.utf8/LC_NUMERIC
    b7c36000-b7c37000 r–p 00000000 08:02 6432825 /usr/lib/locale/it_IT.utf8/LC_TIME
    b7c37000-b7d18000 r–p 00000000 08:02 6374243 /usr/lib/locale/it_IT.utf8/LC_COLLATE
    b7d18000-b7d19000 r–p 00000000 08:02 6374379 /usr/lib/locale/it_IT.utf8/LC_MONETARY
    b7d19000-b7d1a000 rw-p b7d19000 00:00 0
    b7d1a000-b7e63000 r-xp 00000000 08:02 11150721 /lib/tls/i686/cmov/libc-2.7.so
    b7e63000-b7e64000 r–p 00149000 08:02 11150721 /lib/tls/i686/cmov/libc-2.7.so
    b7e64000-b7e66000 rw-p 0014a000 08:02 11150721 /lib/tls/i686/cmov/libc-2.7.so
    b7e66000-b7e69000 rw-p b7e66000 00:00 0
    b7e69000-b7e73000 r-xp 00000000 08:02 11132992 /lib/libgcc_s.so.1
    b7e73000-b7e74000 rw-p 0000a000 08:02 11132992 /lib/libgcc_s.so.1
    b7e74000-b7e97000 r-xp 00000000 08:02 11150729 /lib/tls/i686/cmov/libm-2.7.so
    b7e97000-b7e99000 rw-p 00023000 08:02 11150729 /lib/tls/i686/cmov/libm-2.7.so
    b7e99000-b7e9a000 rw-p b7e99000 00:00 0
    b7e9a000-b7f4a000 r-xp 00000000 08:02 6342728 /usr/lib/libstdc++.so.5.0.7
    b7f4a000-b7f4f000 rw-p 000af000 08:02 6342728 /usr/lib/libstdc++.so.5.0.7
    b7f4f000-b7f54000 rw-p b7f4f000 00:00 0
    b7f54000-b7f55000 r–p 00000000 08:02 6381598 /usr/lib/locale/it_IT.utf8/LC_MESSAGES/SYS_LC_MESSAGES
    b7f55000-b7f56000 r–p 00000000 08:02 6374250 /usr/lib/locale/it_IT.utf8/LC_PAPER
    b7f56000-b7f57000 r–p 00000000 08:02 6374402 /usr/lib/locale/it_IT.utf8/LC_NAME
    b7f57000-b7f58000 r–p 00000000 08:02 6432827 /usr/lib/locale/it_IT.utf8/LC_ADDRESS
    b7f58000-b7f59000 r–p 00000000 08:02 6432828 /usr/lib/locale/it_IT.utf8/LC_TELEPHONE
    b7f59000-b7f5a000 r–p 00000000 08:02 6374246 /usr/lib/locale/it_IT.utf8/LC_MEASUREMENT
    b7f5a000-b7f61000 r–s 00000000 08:02 6357926 /usr/lib/gconv/gconv-modules.cache
    b7f61000-b7f62000 r–p 00000000 08:02 6432829 /usr/lib/locale/it_IT.utf8/LC_IDENTIFICATION
    b7f62000-b7f71000 r-xp 00000000 08:02 11150749 /lib/tls/i686/cmov/libresolv-2.7.so
    b7f71000-b7f73000 rw-p 0000f000 08:02 11150749 /lib/tls/i686/cmov/libresolv-2.7.so
    b7f73000-b7f75000 rw-p b7f73000 00:00 0
    b7f75000-b7f7e000 r-xp 00000000 08:02 11150725 /lib/tls/i686/cmov/libcrypt-2.7.so
    b7f7e000-b7f80000 rw-p 00008000 08:02 11150725 /lib/tls/i686/cmov/libcrypt-2.7.so
    b7f80000-b7fa7000 rw-p b7f80000 00:00 0
    b7fa7000-b7fa9000 r-xp 00000000 08:02 11150727 /lib/tls/i686/cmov/libdl-2.7.so
    b7fa9000-b7fab000 rw-p 00001000 08:02 11150727 /lib/tls/i686/cmov/libdl-2.7.so
    b7fab000-b7fbf000 r-xp 00000000 08:02 11150747 /lib/tls/i686/cmov/libpthread-2.7.so
    b7fbf000-b7fc1000 rw-p 00013000 08:02 11150747 /lib/tls/i686/cmov/libpthread-2.7.so
    b7fc1000-b7fc5000 rw-p b7fc1000 00:00 0
    b7fc5000-b7fc6000 r-xp b7fc5000 00:00 0 [vdso]
    b7fc6000-b7fe0000 r-xp 00000000 08:02 11132947 /lib/ld-2.7.so
    b7fe0000-b7fe2000 rw-p 00019000 08:02 11132947 /lib/ld-2.7.so
    bf8ef000-bf904000 rw-p bffeb000 00:00 0 [stack]
    Deleting temporary files…

    It’s a real SHAME that in Ubuntu the compatibility libs are still NOT WORKING

  11. Hong

    Cool tips, Thanks!

  12. smdelfin

    This also worked for DB2 Express-C 9.5.2 on Ubuntu 8.10. Thanks!

  13. WBRB

    I would encourage the use of google before posting that ubuntu has no root account or at least qualifying it with something like “enabled by default”.

    Results 1 – 10 of about 270,000 for ubuntu enable root.

  14. Antonio Cangiano

    Just to clarify: WBRB is replying to David. I never claimed that a root account cannot be enabled on Ubuntu.

  15. Hannes

    I installed DB2 Express-C 9.5.2 on Ubuntu 9.04. but on an USB-Disk to have it fully portable. Installation was succesfull. But as I am a newbie on this can anyone please provide a tip how to start a GUI to manage the DB? Many Thanks in advance.

  16. Hannes Eva

    Dear db-freaks,

    here you receive a warp-up in short for a successful db2 installation (even on a usb-device with ubuntu:)

    set the visual effects of desktop to none
    (this is for neccessary for the db2cc)

    sudo gedit /etc/sysctl.conf
    insert the following:
    ########################
    kernel.shmmax = 256000000
    ########################
    save the file

    sudo apt-get install libstdc++5

    sudo apt-get install libaio-dev
    cd /media/…pathtodb2source…/db2exp

    sudo ./db2setup
    – install with English language only to
    avoid errors installing the sample-db
    – use a secure psw for dasusr1,dbinst1,…
    – installing Textsearch returned errors
    on my system, I didn’t install it.

    login to user: db2inst1
    db2sampl -force << db2-Sample-Datenbank
    db2start << starts db2

    db2stop << stops db2
    db2cc << starts commandcenter

    now you can reinstall db/2 on this existing installation to install the language pack

    have a fun with a db-engine you can use from a usb-/stick/drive and on a pc/workstation/mainframe/supercomputer

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.