Tips & tricks for installing and running IBM products

Install DB2 V10.1

Tom Bosmans  7 January 2014 15:28:32

Install DB2 10.1

DB2 v10.1 is a common component for quite a few ICS (formerly Lotus) products.  This is a short guide to install it .

This is based on and updated from an earlier article , on DB2 V9.7 : 19122012151226TBOJNU.htm

Packages required :

yum install compat-libstdc++-33
yum install libaio

Make sure you have a hostname that can be resolved.  This may require tinkering with the host file in Proof of concept scenarios:

vi /etc/hosts


DB2 cannot be installed as non-root , so must be installed as root .
Note that  dasusr is no longer supported in V10, so it's no longer necessary to create these users.

Workaround for Tivoli SA MP

You need to do this to install Tivoli SA MP (needed if you want to do HADR)
as root :
vi /etc/redhat-release

this is by default in my case
CentOS release 6.5 (Final)

Change it to :
Red Hat Enterprise Linux Server release 6.5

Create users and groups

Create Groups

groupadd db2iadm1
groupadd db2fadm1

Create Users

useradd -u 1004 -g db2iadm1 -m -d /home/db2inst1 db2inst1
useradd -u 1003 -g db2fadm1 -m -d /home/db2fenc1 db2fenc1

Set password for these users

echo passw0rd | passwd db2inst1 --stdin
echo passw0rd | passwd db2fenc1 --stdin


Extract the install file to a directory :
In my case, the extracted file ends up here:  /mnt/hgfs/hostroot/local/Downloads/IBM/Sametime/90/wser

cd /mnt/hgfs/hostroot/local/Downloads/IBM/Sametime/90/wser

Run the precheck uititly


You may want to set the selinux level to permissive :

(as root) vi /etc/selinux/config

Change the level to permissive or disabled.

Although the library is installed, the db2prereqcheck utility can't find the library .
DBT3514W  The db2prereqcheck utility failed to find the following 32-bit library file: "".

Install DB2

Start the installer :

Enter "wse" to install the enterprise server
Accept the default installation location
Enter "no" for the PureScale feature

Check the log file .

Create the instance

You need to make sure the hostname of the system can be resolved (through DNS or through the hosts file)
[root@stssc instance]# ./db2icrt -u db2fenc1 db2inst1

The execution completed successfully.

For more information see the DB2 installation log at "/tmp/db2icrt.log.47196".
DBI1070I  Program db2icrt completed successfully.

Check if the instance exists :

[root@stssc instance]# ./db2ilist

Setup DB2  

Configure the services file

[root@stssc instance]# vi /etc/services
db2sametime     50000/tcp               # DB2

Switch to the db2inst1 user and reference the service entry you just created, and set the communication type to TCPIP

[root@stssc instance]# su - db2inst1
[db2inst1@stssc ~]$
[db2inst1@stssc ~]$ db2set DB2COMM=TCPIP
[db2inst1@stssc ~]$ db2 update db manager configuration using svcename db2sametime

[db2inst1@stssc ~]$ exit

As root , configure autostart :
Start with sourcing the instance profile :

[root@stssc instance]# . /home/db2inst1/sqllib/db2profile
[root@stssc instance]# db2iauto -on db2inst1
[root@stssc instance]# db2set -all
[g] DB2INSTDEF=db2inst1
[g] DB2ADMINSERVER=dasusr1

[root@stssc ~]# cd /opt/ibm/db2/V10.1/bin
[root@stssc bin]# ./db2fm -i db2inst1 -U
[root@stssc bin]# ./db2fm -i db2inst1 -u
[root@stssc bin]# ./db2fm -i db2inst1 -f on


As instance owner, check the state
db2fm -s -S

When the system starts, now the db2inst1 instance should start automatically.

If this doesn't work, one thing to check is if you haven't got the dasadmin setup .  This will cause segmentation faults in the Fault Monitor, and the db2inst1 instance will not be started automatically.