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 ./db2setupI hope this quick tip saves you some time and a headache.
Get more stuff like this
Subscribe to my mailing list to receive similar updates about programming.
Thank you for subscribing. Please check your email to confirm your subscription.
Something went wrong.
> 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
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
> 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. 😛
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.
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.
If the setup window is completely grey, without any widgets, then try to disable the visual effects under Ubuntu.
System -> Appearance -> Visual Effects -> None.
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.
Please be connected to the internet while installing the library files
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
Cool tips, Thanks!
This also worked for DB2 Express-C 9.5.2 on Ubuntu 8.10. Thanks!
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.
Just to clarify: WBRB is replying to David. I never claimed that a root account cannot be enabled on Ubuntu.
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.
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