Installing DB2 on Ubuntu

On January 30th, 2006, IBM released a no-charge version of DB2 called DB2 Express-C. This was an expected response to the recently announced free versions of Oracle 10g and Microsoft SQL Server. Unlike Microsoft or Oracle's free editions, Express-C has no limit on number of users or on database size.

While versions 8.2 and 9.1 of DB2 Express-C imposed hardware limits on the server on which it ran, DB2 Express-C 9.5 can run on Windows and Linux machines of any size, but the database engine will not utilize more than two CPU cores and 2GB RAM.

In 2007, IBM introduced a yearly support subscription called the Fixed Term License (FTL), which offers a year of telephone support for Express-C for US$3000 per server. Purchasing the FTL also allows the DB2 Express-C engine to use up to four CPU cores and 4GB RAM. Users of DB2 Express-C who don't purchase an FTL subscription can receive support and assistance on a free, public web forum staffed by IBM technicians and other DB2 users.

Visit here for software available from IBM. According to this page, DB2 can be installed on ubuntu.

According to this page, DB2 can be installed on Ubuntu.

Download software

To download DB2 trial visit here and select: IBM DB2 9.5 Data Server trial. Then you have to sign in (create an account if not already created) in order to download. Choose either of the following:

• DB2 9.5 data server trial for Linux(R) on AMD64 and Intel(R) EM64T systems (x64)
• DB2 9.5 data server trial for Linux(R) on System z

Then answer questions and click 'I confirm' at the bottom. Finally click 'I confirm' button to start downloading.

Alternately, visit here and select: IBM DB2 9.5 Express-C. Then choose DB2 Express-C 9.5 for Linux and click continue. Then answer questions and click 'I confirm' at the bottom. Finally select either of the following:

• DB2 Express-C for Linux operating system, 32-bit architecture
• DB2 Express-C for Linux operating system, 64-bit architecture

click 'I confirm' button to start downloading.

Installing DB2

I choose 'DB2 Express-C for Linux operating system, 32-bit architecture' to demonstrate how to install. If you have chosen a different version, make necessary changes accordingly. Let's assume the downloaded file is on your home directory. Then do the following:

tar -xf db2exc_950_LNX_x86.tar.gz

cd ~/exp

sudo apt-get install libaio1

sudo apt-get install libstdc++5

sudo ./db2setup

Select 'Install a Product' from the left side of the generated window and click 'Install New'. Another window will be opened. Follow he instructions to complete the installation. You are encouraged to create new user and groups (dasusr1/dasadm1, db2inst1/db2iadm1, db2fenc1/db2fadm1) during installation.

Uninstalling DB2

If you have installed with all default settings (as mentioned above) then just running the following commands would remove the db2 completely. In case you have changed something during installation, then make appropriate changes accordingly.

cd /opt/ibm/db2/V9.5

./instance/db2ilist

sudo instance/db2idrop db2inst1

sudo install/db2_deinstall -a

cd && sudo rm -r /opt/ibm/

sudo userdel -r dasusr1

sudo userdel -r db2fenc1

sudo userdel -r db2inst1

sudo groupdel dasadm1

sudo groupdel db2fadm1

sudo groupdel db2iadm1

Before running those commands, please make sure:

· Make sure, db2 is not running.

· Identify DB2 installation directory (E.g /opt/ibm/db2/V9.5)

· Identify DB2 instances (using db2ilist command, see the second command)

· Drop each and every instances (using db2idrop command, third command)

· If you have other IBM softwares in /opt/ibm then remove only /opt/ibm/db2 directory.

· Delete user and group accounts that you have created for db2.