Install DB2 V10.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 : Install Tivoli Directory server
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
{ip address} 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
groInstall Tivoli Directory serverupadd 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)
./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 :
./db2ilist > db2inst1
Setup DB2
Configure the services file
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.