Installing DB2 V9.5 on Linux

Posted at Thursday, May 22, 2008
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: ,