Installing DB2 Express V9

Here below is a guide for the installation of DB2 Express V9.5 available from IBM.

Prerequisites

• First of all download the version to install from the following link: DB2 Express
• Have access rights to the root user.

Installation

To install a DB2 product using the script db2_install:
Log in as root.
Move to the root directory of installation resulting from decompression of the file downloaded.
Enter the command db2_install in a shell prompt to start the script db2_install. The script db2_install prompts you to enter one of the following keywords

(depending on the product that you DB2 version). In our case the only choice will be:

DB2.EXP 	for DB2 Express Edition or DB2 Express Edition 

Enter the keyword of the product you want to install.

The installation directory for the DB2 software is: /opt/ibm/db2/V9.5

Configuration

Now that DB2 is installed, create groups, users, administrator account and the DB2 database instance for the database.
The table below summarizes the groups and users to create:

]

Follow these steps:

• Login as root
  • Create groups

groupadd -g 999 db2iadm1
groupadd -g 998 db2fadm1
groupadd -g 997 dasad

*

• • Create users

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 

• Create the administration server

/opt/IBM/db2/V8.1/instance/dascrt -u dasusr1

• Creating the database instance

/opt/IBM/db2/V8.1/instance/db2icrt -a server -u db2fenc1 db2inst1

• Enabling remote connections

To enable remote connections to the database:
Set the communication port that DB2 should use. You must use a user "db2inst1" and execute the command (/ opt/ibm/db2/V9.5/bin):

db2 update dbm cfg using svcename 50055 

Establish the communication protocol that DB2 should use. You must use a user "db2inst1" and execute the command (/ opt/ibm/db2/V9.5/adm):

db2set DB2COMM=tcpip

Restart the database (/ opt/ibm/db2/V9.5/adm)

db2stop
	db2start

Start the database server (/ opt/ibm/db2/V9.5/das/bin)

db2admin start

[http://static.commentcamarche.net/en.kioskea.net/faq/images/3036 sdfg.png