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


About This Document
Procedure for Making an Instance

About This Document

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.

Procedure for Making an Instance

  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.

Making an Instance for DB2 (v1.1-1.2) on AIX: instance.v11-12.325-41.dbs ITEM: FAX
Dated: 99/02/24~00:00 Category: dbs
This HTML file was generated 99/06/24~12:41:58
Comments or suggestions?
Contact us