Tuesday, July 11, 2006

Create 2nd DB2 Instance

To create the second instance on DB2 server(version 8.1), do the following steps,

1. as root

#useradd -g db2grp1 db2inst2
#passwd db2inst2
(give a password, e.g. passw0rd)

2. as root (take DB2 default installation on Linux as example)

#/opt/IBM/db2/V8.1/instance/db2icrt -a SERVER -p 50001 -u db2fenc1 db2inst2

or

add an entry at the bottom of /etc/services file, "db2c_db2inst2 50001/tcp"
#/opt/IBM/db2/V8.1/instance/db2icrt -a SERVER -p db2c_db2inst2 -u db2fenc1 db2inst2

or
add an entry at the bottom of /etc/services file, "db2c_db2inst2 50001/tcp"
#/opt/IBM/db2/V8.1/instance/db2icrt -a SERVER -u db2fenc1 db2inst2
#su - db2inst2
$db2set DB2COMM=tcpip -i db2inst2
$db2 update dbm cfg using SVCENAME db2c_db2inst2

3. new DB2 instance db2inst2 is ready.

No comments: