Creating the Instance using db2icrt

Only one instance can be created under a user name. db2icrt command is not available for a non-root installation of DB2 database products on Linux and UNIX operating systems.

1) Login in as root. If you are using the su command to become the root user ensure to issue the su command with the '-' option. This sets the environment as if you had logged in to the system using the "login" command.

2) Creating an instance for the user ID db2v97 on a client machine.

DB2DIR/instance/db2icrt db2v97 (where DB2DIR is the install location)

Install path in this example is "/opt/ibm/db2/V9.7". Now ran the following command "instance" directory under the install path.

./db2icrt db2v97
DBI1070I  Program db2icrt completed successfully.

3) Creating an instance for the user ID db2v97 and db2fenc on a server machine.

 ./db2icrt -u db2fenc db2v97
DBI1070I  Program db2icrt completed successfully.

The -u option specifies the fenced user ID. It is mandatory to create a fence ID while creating the instance on a server machine. You can also use the same user for the fence ID as well. Here is an example:

 ./db2icrt -u db2v97 db2v97
DBI1070I  Program db2icrt completed successfully.

Note that it is not supported to run db2icrt command when you source the DB2 instance environment.

Good Luck everyone!!

Thanks
Samyn