Install DB2 in linux

DB2 installation in linux-general Linux technology-Linux technology and application information. For more information, see the following section. Installation environment:
RHEL5.2 64-bit Operating System
DB2 V9.7 Database

First, download the DB2 installation package in linux:
DB2_ESE_97_Linux_x86_64.tar
V9.7fp2_linuxx64_universal_fixpack.tar (upgrade package)

The installation procedure is as follows:

1. Create users and user groups

Required User example username example group name
Instance owner db2instdb2grp
Protected user db2fencdb2fgrp
DB2 Management Server user dasuserdasgrp

2. Install db2

[Wwl] [root] [/] # cd/soft_ins/ese
[Wwl] [root] [/soft_ins/ese] #./db2_install

Default directory for installation of products-/opt/IBM/db2/V9.5
**************************************** *******************
Do you want to choose a different directory to install [yes/no]?
Yes
Enter full path name for the install directory-

------------------------------------------------
/Db2/V9.5

Specify one of the following keywords to install DB2 products.
ESE
CLIENT
RTCL

Enter "help" to redisplay product names.
Enter "quit" to exit.
**************************************** *******************
ESE
......

3. Install and update

[Wwl] [root] [/soft_ins/ese] # cd/soft_ins/universal
[Wwl] [root] [/soft_ins/universal] #./installFixPack

Enter full path name for the install directory-

------------------------------------------------
/Db2/V9.5
......

4. Create a db2 User Manager and start

[Wwl] [root] [/soft_ins] # cd/opt/IBM/db2/V9.5/instance
[Wwl] [root] [/opt/IBM/db2/V9.5/instance] #./dascrt? U dasuser

[Wwl] [root] [/opt/IBM/db2/V9.5/instance] # su-dasuser
[Wwl] [dasuser] [/home/dasuser] # db2admin start
[Wwl] [dasuser] [/home/dasuser] # exit

5. Create a db2 user instance and start it.

[Wwl] [root] [/opt/IBM/db2/V9.5/instance] #./db2icrt? U db2fenc? S ese db2inst
[Wwl] [root] [/opt/IBM/db2/V9.5/instance] #/opt/IBM/db2/V9.5/cfg/db2ln

[Wwl] [root] [/opt/IBM/db2/V9.5/instance] # su-db2inst
[Wwl] [db2inst] [/home/db2inst] # db2start

6. Set Some db2 parameters.

Communication Protocol
[Wwl] [db2inst] [/home/db2inst] # db2set DB2COMM = tcpip

Listening port
[Wwl] [db2inst] [/home/db2inst] # db2 update dbm cfg using svcename 50000

Configure oracle compatibility
[Wwl] [db2inst] [/home/db2inst] # db2set DB2_COMPATIBILITY_VECTOR = ORA
[Wwl] [db2inst] [/home/db2inst] # db2set DB2_DEFERRED_PREPARE_SEMANTICS = yes
[Wwl] [db2inst] [/home/db2inst] # db2stop force
[Wwl] [db2inst] [/home/db2inst] # db2start