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

                  stssc.tb.issc.ibm.com


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

Installation


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

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


Run the precheck uititly


./db2prereqcheck

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 libstdc++.so.5 .
DBT3514W  The db2prereqcheck utility failed to find the following 32-bit library file: "libstdc++.so.5".

Install DB2


Start the installer :
./db2_install


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
db2inst1


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
DB20000I  The UPDATE DATABASE MANAGER CONFIGURATION command completed
successfully.

[db2inst1@stssc ~]$ exit
logout

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
[i] DB2COMM=TCPIP
[i] DB2AUTOSTART=YES
[g] DB2SYSTEM=stssc.tb.issc.ibm.com
[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


http://www-01.ibm.com/support/docview.wss?uid=swg21209001

Reboot

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.