DB2 Client

How to install DB2 client on Unix

Usually we use DB2 clients from /home/dbclient_Linux(or AIX, Solaris)/db2, but due to security concerns, IT put some restrictions to DB2 clients which would not allow us to have write access to DBCLIENT directory, it means, if you want to use DB2 clients on Unix, you need to ask IT to add the node and database for you.

If you do not want to involve IT for DB2 client usage, you can install your own DB2 client on your machine. The tradeoff is that you need to install for many times as the client would be installed locally, for example, if you are using box1 for a while, then you need to use another box2, you should install DB2 client on box2.

Here are steps to install DB2 client on Linux: (similar steps for AIX/Solaris, just some commands differences)

step1:

login to your Linux box using root account

step2:

# cd /build

step3:

# makedir db2_client_install_pkg

step4:

get installation package and put in in /build/db2_client_install_pkg (for e.g. the installation package is DB2_DSClient_V10.5_Linux_x86-64.tar.gz)

step5:

# tar svzf DB2_DSClient_V10.5_Linux_x86-64.tar.gz

step6:

After step5, there would be a new directory: client under /build/ db2_client_install_pkg

step7:

# cd client
# ./db2_install

it would ask you if you need to install DB2 client on the default path /opt/db2/v10.5(something similar like that), you could choose no, and specify a path, such as /build/db2v105

step8:

create a new directory under /build, named db2_user, then create users and groups

# groupadd –g 901 db2grp
# groupadd –g 902 db2fgrp
# groupadd –g 903 db2agrp 
# useradd –u 1044 –g db2grp –m –d /build/db2_user/db2inst1 db2inst1
# useradd –u 1043 –g db2fgrp –m –d /build/db2_user/db2fenc1 db2fenc1
# useradd –u 1042 –g db2agrp –m –d /build/ db2_user/dasusr1 dasusr1

after finishing add groups and users, you would notice under /build, there are those new directories.

remember to change passwords for all the users.

step9:

DB2 instance initialization.

# cd /build/db2v105/instance
# ./db2icrt -a server -u db2inst1 db2inst1

step10:

after the initialization, you would notice there are more files/directories under /build/db2_user/db2inst1

stpe11:

# cp /build/db2_user/db2inst1/sqllib/db2profile  /etc/profile.d/db2profile.sh

step12:

under /build/db2_user/db2inst1/sqllib, source db2profile and then to use db2.

step13:

now you can use db2 command to catalog your node and database, and then connect to your own DB2 database.