15. Installing DB2 Express-C on Ubuntu 6.06 LTS 'Dapper Drake'

15.1. Installation notes

Since you cannot log in as root directly with an Ubuntu system, this DB2 installation is run as the default user created during Ubuntu setup (i.e. the regular user account with 'sudo' capability).

There are two ways of installing DB2 Express-C 9 on Ubuntu. The harder of the two methods is to use the default DB2 db2setup, and then make adjustments to the Ubuntu system afterwards to handle the slight differences of Ubuntu's Debian-based packaging system. For reasons of clarity and brevity, I will omit the instructions for doing it this more difficult way; however, if you would like to see these instructions, please send me an email ([email protected]) and I will pass them along.

The easy way to install DB2 Express-C on Ubuntu 6.06 LTS is to use the Synaptic package installer, and almost everything is done for you, from downloading to installation and configuration. Here's how to do it:

1. Under the Applications menu on the Ubuntu menu bar, choose Add/Remove.

2. Once the Synaptic package manager application has started up, click the Show commercial applications checkbox.

3. In the Search bar, type "DB2" and hit the Enter key.

4. DB2 Express should show up as the only result. If you don't see it, make sure that Synaptic is displaying All Applications or Third party applications.

5. Enable the dapper-commercial channel if requested by clicking the "Enable channel" button.

6. Click "Apply".

After hitting the "Apply" button, Synaptic will download the DB2 Express-C package, along with a few dependent libraries, then unpack and install the package and finally configure the DB2 users and default instance.

15.2. Post-installation notes

After installation by Synaptic, there are a few steps required to get DB2 up and running smoothly.

1. Usable passwords for the DB2 default accounts.

   To actually log in or connect to the DB2 databases and servers using the default DB2 users (db2inst1, db2fenc1, and dasusr1), you need to modify the initial passwords. To do this, open a terminal (as the regular user), and type sudo su - to get root access. Then run these three commands:

   passwd db2inst1 passwd db2fenc1 passwd dasusr1

   Each time you will be asked to set the new password for the specified user account.

2. Change the default shell for the DB2 default accounts.

   The default command shell for the DB2 accounts is set as just a plain old /bin/sh. To get the handy features of the BASH shell, you'll want to change it for these three accounts. In the same root access command window, open the /etc/passwd file in your favorite text editor and change:

   db2inst1:x:1001:1001::/home/db2inst1:/bin/sh db2fenc1:x:1002:1002::/home/db2fenc1:/bin/sh dasusr1:x:1003:1003::/home/dasusr1:/bin/sh

   to

   db2inst1:x:1001:1001::/home/db2inst1:/bin/bash db2fenc1:x:1002:1002::/home/db2fenc1:/bin/bash dasusr1:x:1003:1003::/home/dasusr1:/bin/bash

3. Enable DB2 service ports for remote connections.

   To enable outside users to get to your DB2 databases, you'll need to set up the DB2 service port, as it is not configured by the Synaptic installation process.

   As the regular user, run sudo vi /etc/services and add this line to the end of the file and save the changes:

   db2c_db2inst1 50001/tcp # IBM DB2 instance - db2inst1

   Then, as the DB2 instance owner (db2inst1 by default), run these commands:

   db2 update dbm cfg using SVCENAME db2c_db2inst1 db2set DB2COMM=tcpip db2stop db2start

   Now remote users will be able to connect to the DB2 databases on your Ubuntu system.

4. Enable remote DB2 administration connections.

   To allow remote administration of your DB2 server, you'll need to set up the DB2 DAS connection port, as it is not configured by the Synaptic installation process.

   As the regular user, run sudo vi /etc/services and add this line to the end of the file:

   ibm-db2 523/tcp # IBM DB2 DAS ibm-db2 523/udp # IBM DB2 DAS

   Then, as the DB2 DAS owner (dasusr1 by default), run these commands:

   db2admin stop db2admin start

   Now remote administrators can connect to the DAS server to administer databases on your Ubuntu system.