Creating required users for a Db2 server installation in a partitioned database environment (AIX)

Three users and groups are required to operate Db2 databases in partitioned database environments on AIX® operating systems.

Before you begin

• You must have root user authority to create users and groups.
• If you manage users and groups with security software, additional steps might be required when defining Db2 users and groups.

About this task

The user and group names used in the following instructions are documented in the following table. You can specify your own user and group names if they adhere to your system naming rules and Db2 naming rules.

If you are planning to use the Db2 Setup wizard to install your Db2 database product, the Db2 Setup wizard will create these users for you.

Table 1. Required users and groups

Required user	User name	Group name
Instance owner	db2inst1	db2iadm1
Fenced user	db2fenc1	db2fadm1

Restrictions

The user names you create must conform to both your operating system's naming rules, and those of the Db2 database system.

To create all three of these users, perform the following steps:

1. Log on to the primary computer.
2. Create a group for the instance owner (for example, db2iadm1) and the group that will run UDFs or stored procedures (for example, db2fadm1) by entering the following commands:

      mkgroup id=999 db2iadm1
      mkgroup id=998 db2fadm1
     

3. Create a user that belongs to each group that you created in the previous step using the following commands. The home directory for each user will be the Db2 home directory that you previously created and shared (db2home).

   mkuser id=1004 pgrp=db2iadm1 groups=db2iadm1 home=/db2home/db2inst1
      core=-1 data=491519 stack=32767 rss=-1 fsize=-1 db2inst1
   mkuser id=1003 pgrp=db2fadm1 groups=db2fadm1 home=/db2home/db2fenc1 
      db2fenc1 
   

4. Set an initial password for each user that you created by entering the following commands:

      passwd db2inst1
      passwd db2fenc1
      

5. Log out.
6. Log on to the primary computer as each user that you created (db2inst1 and db2fenc1). You might be prompted to change each user's password because this is the first time that these users have logged onto the system.
7. Log out.
8. Create the exact same user and group accounts on each computer that will participate in your partitioned database environment.