Installing DB2 V9.5 on Linux

Get the Software Here:

DB2 9 Trial Download

Reference the Following Documentation:

Information Center DB2 9.5 Documentation

Unpack the Software and Satisfy any Prerequisites

export DISPLAY=192.168.1.3:0.0

# gunzip db2_v95_linuxia32_server.tar.gz
# tar -xvf db2_v95_linuxia32_server.tar

Note that these are the recommended kernel values

kernel.shmmax=268435456 for 32-bit; 1073741824 for 64-bit
kernel.msgmni=1024
fs.file-max=8192
kernel.sem=”250 32000 32 1024”

Install Database Engine

# ./server/db2_install -f NOTSAMP

Default directory for installation of products - /opt/ibm/db2/V9.5

***********************************************************
Do you want to choose a different directory to install [yes/no] ?
no


Specify one of the following keywords to install DB2 products.

  ESE
  CONSV
  WSE
  EXP
  PE
  CLIENT
  RTCL

Enter "help" to redisplay product names.

Enter "quit" to exit.

***********************************************************
ESE
DB2 installation is being initialized.

Total number of tasks to be performed: 41
Total estimated time for all tasks to be performed: 1461

The execution completed successfully.

For more information see the DB2 installation log at
"/tmp/db2_install.log.6602".

Perform Post-Installation Tasks

Add O/S User and Groups

# groupadd -g 999 db2iadm1
# groupadd -g 998 db2fadm1
# groupadd -g 997 dasadm1
# 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

Set the Passwords

# passwd db2inst1
# passwd db2fenc1
# passwd dasusr1

Create the DAS Instance

# cd /opt/ibm/db2/V9.5/instance/
# ./dascrt -u dasusr1
SQL4406W  The DB2 Administration Server was started successfully.
DBI1070I  Program dascrt completed successfully.

Create a DB2 Instance

# cd /opt/ibm/db2/V9.5/instance
# ./db2icrt -a server -u db2fenc1 db2inst1
DBI1070I  Program db2icrt completed successfully.

Create Symbolic Links to DB2 Binaries

# cd /opt/ibm/db2/V9.5/cfg
# ./db2ln
# ls -lart /usr/lib/*db2* | wc -l
6
# ls -lart /usr/include/*db2* | wc -l
8

Setup Communications

Verify Service File Entry

# grep db2c_db2inst1 /etc/services
db2c_db2inst1   50000/tcp

Update the Service Name

# su - db2inst1
# . $HOME/sqllib/db2profile
# db2
db2 => update dbm cfg using svcename db2c_db2inst1;
DB20000I  The UPDATE DATABASE MANAGER CONFIGURATION command completed
successfully.

# db2stop
05/23/2008 14:03:33     0   0   SQL1032N  No start database manager command was issued.
SQL1032N  No start database manager command was issued.  SQLSTATE=57019

# db2start
05/23/2008 14:03:46     0   0   SQL1063N  DB2START processing was successful.
SQL1063N  DB2START processing was successful.
# db2 get database manager configuration | grep "TCP/IP Service name"
 TCP/IP Service name                          (SVCENAME) = db2c_db2inst1;

# db2set DB2COMM=tcpip
# db2stop
05/23/2008 14:50:03     0   0   SQL1064N  DB2STOP processing was successful.
SQL1064N  DB2STOP processing was successful.
# db2start
05/23/2008 14:50:14     0   0   SQL1063N  DB2START processing was successful.
SQL1063N  DB2START processing was successful.

Enable SSL Support

# export DISPLAY=192.168.1.3:0.0
# export JAVA_HOME=$HOME/sqllib/java/jdk32
# export PATH=$PATH:/usr/local/ibm/gsk7/bin
# gsk7ikm

Create the Key Store Database as well as a Self-signed Certificate















Create the SSLconfig.ini File and Populate with Correct Values

# touch $HOME/sqllib/cfg/SSLconfig.ini
# vi $HOME/sqllib/cfg/SSLconfig.ini

SSLconfig.ini

DB2_SSL_KEYSTORE_FILE=/home/db2inst1/GSKit/Keystore/key.kdb
DB2_SSL_KEYSTORE_PW=password
DB2_SSL_LISTENER=40000

# db2set DB2COMM=SSL,TCPIP
# db2stop
05/23/2008 15:50:13     0   0   SQL1064N  DB2STOP processing was successful.
SQL1064N  DB2STOP processing was successful.
# db2start
05/23/2008 15:50:20     0   0   SQL1063N  DB2START processing was successful.
SQL1063N  DB2START processing was successful.

Create the Tools Catalog for Task Center/Control Center

# db2 create database TOOLSDB AUTOMATIC STORAGE YES ON /u01/app/ibm/data
DB20000I  The CREATE DATABASE command completed successfully.
# db2 create tools catalog toolscat use existing database toolsdb force
DB20000I  The CREATE TOOLS CATALOG command completed successfully.

Update the DAS Configuration, Verifying Values

# db2 update admin configuration using smtp_server localhost
DB20000I  The UPDATE ADMIN CONFIGURATION command completed successfully.
# db2 update admin configuration using dasadm_group dasadm1
DB20000I  The UPDATE ADMIN CONFIGURATION command completed successfully.
# db2 get admin configuration

            Admin Server Configuration

 Authentication Type DAS                (AUTHENTICATION) = SERVER_ENCRYPT

 DAS Administration Authority Group Name  (DASADM_GROUP) = dasadm1

 DAS Discovery Mode                           (DISCOVER) = SEARCH
 Name of the DB2 Server System               (DB2SYSTEM) = RAC1

 Java Development Kit Installation Path DAS   (JDK_PATH) = AUTOMATIC (/home/db2inst1/sqllib/java/jdk32)
 Java Development Kit Installation Path DAS   (JDK_64_PATH) = AUTOMATIC (/home/db2inst1/sqllib/java/jdk32)

 DAS Code Page                            (DAS_CODEPAGE) = 0
 DAS Territory                           (DAS_TERRITORY) = 0

 Location of Contact List                 (CONTACT_HOST) =
 Execute Expired Tasks                   (EXEC_EXP_TASK) = NO
 Scheduler Mode                           (SCHED_ENABLE) = ON
 SMTP Server                               (SMTP_SERVER) = localhost
 Tools Catalog Database                    (TOOLSCAT_DB) = TOOLSDB
 Tools Catalog Database Instance         (TOOLSCAT_INST) = db2inst1
 Tools Catalog Database Schema         (TOOLSCAT_SCHEMA) = TOOLSCAT
 Scheduler User ID                                       =

 Diagnostic error capture level              (DIAGLEVEL) = 2

Labels: DB2, Installation