Making an Instance for DB2 (v1.1-1.2) on AIX

This document describes how to make an instance for DB2 v1.1 and v1.2 and applies to AIX Versions 3.2.5 and 4.1.

1. Log in as root.

2. Create a group and user for the database instance owner, such as:

      mkgroup sysadm1 
      mkuser pgrp=sysadm1 groups=sysadm1 home=/home/inst1 inst1 
      passwd inst1  (set the password for inst1) 
   

   NOTE: There are restrictions on naming the group and user. Documentation appears in the DB2 Installation Guide. These restrictions vary slightly across platforms. In the preceding example, inst1 is the instance owner and sysadm1 is the group.

3. Use the instance command:

      /usr/lpp/db2_01_01_0000/instance/db2instance inst1 
   

   Executing this command creates a new directory tree under /home/inst1/sqllib. This should not be altered or used outside of the database.

4. Edit the .profile created in /home/inst1.

      vi /home/inst1/.profile 
   

   Add the following line:

      . /home/inst1/sqllib/db2profile 
   

   NOTE: There is a . (period) before the path beginning with /home. If you forget the . (period), the command will not update your current shell.

5. You have completed the process of making an instance. Now log in as the instance owner and proceed to issue a db2start.