A good solution for linux DB2 v9.7!

This article describes how to install linux DB2 v9.7, however, you do not know how to solve the problem correctly, so the following articles must be good teachers and friends for you.

1 installation package v9.7_linuxia32_server.tar.gz

2. Decompress tar-zxvf v9.7_linuxia32_server.tar.gz.

Run DB2setup for graph Installation

Run DB2_install in text mode

1) decompress the installation package

2) execute the installation program

3) create three users: instance users, Restricted Users, and management users.

4) create a Management Server

5) Create an instance

6) Configure TCP/IP communication for the DB2 instance

7) Update the product license key

8) change the DB2 startup mode.

1. Preparations for installing DB2

1) Create mkdir-p/setup/DB2V9.7

2) use ftp or ssh to upload the installation package to the preceding directory.

 
 

  
  
#cd /setup/DB2V9.7  
  
  
#wget ftp://10.32.90.248/tools/%B0%B2%D7%B0%BD%E9%D6%CA/DB2v9.7/v9.7_linuxx64_server.tar.gz 
 
 

3) decompress

 
 

  
  
tar -zvxf v9.7_linuxx64_server.tar.gz 
 
 

2. Run the installer

 
 

  
  
cd /setup/DB2V9.7/server  
  
  
./DB2_install 
 
 

Select "no"

3. Create a group and a user

Create Group

 
 

  
  
#groupadd -g 999 DB2iadm1  
  
  
groupadd -g 998 DB2fadm1  
  
  
groupadd -g 997 dasadm1 
 
 

Create user

 
 

  
  
#useradd -u 1004 -g DB2iadm1 -m -d /home/DB2inst1 DB2inst1  
  
  
useradd -u 1003 -g DB2fadm1 -m -d /home/DB2fenc1 DB2fenc1  
  
  
useradd -u 1002 -g dasadm1 -m -d /home/dasusr1 dasusr1 
 
 

Change User Password

 
 

  
  
#passwd DB2inst1  
  
  
#passwd DB2fenc1  
  
  
#passwd dasusr1 
 
 

4. Create a Management Server

 
 

  
  
#/opt/ibm/DB2/V9.7/instance/dascrt -u dasusr1 
 
 

Create an instance

 
 

  
  
#/opt/ibm/DB2/V9.7/instance/DB2icrt -a SERVER -u DB2fenc1 DB2inst1 
 
 

5. Configure TCP/IP communication for the DB2 instance

Switch to the instance user and start DB2

# Su-DB2inst1

1) Configure DB2

 
 

  
  
$ DB2set DB2_SKIPINSERTED=ON 
  
  
DB2set DB2_EVALUNCOMMITTED=ON 
  
  
DB2set DB2_SKIPDELETED=ON 
  
  
DB2set DB2_HASH_JOIN=YES 
  
  
DB2set DB2_RR_TO_RS=YES 
  
  
DB2set DB2CODEPAGE=1386 
  
  
DB2set DB2COMM=TCPIP 
  
  
DB2set DB2_PARALLEL_IO=*  
  
  
DB2 update dbm cfg using svcename 50000 
 
 

2) Add automatic run

 
 

  
  
$DB2set DB2AUTOSTART=NO 
 
 

$ Su-[Change User to root]

# Vi/etc/rc. local

Add the following content after touch/var/lock/subsys/local:

# Su-DB2inst1-c "DB2start"

3) modify the sysctl. conf file

 
 

  
  
#vi /etc/sysctl.conf  
  
  
kernel.msgmni = 1024 
  
  
kernel.sem = 250 256000 32 1024 
 
 

4) modify the limits. conf file and the soft nofile value in the file.

 
 

  
  
#vi /etc/security/limits.conf  
  
  
* soft nofile 10240 
 
 

10240 maximum number of opened files

Restart the server after modification.

The above content is an introduction to the installation of linux DB2 v9.7. I hope you will find some gains.