Tag Archive | DB2 Users

DB2 users and groups

db2users

  • Instance owner
    • The DB2 instance is created in the instance owner home directory.
    • This user ID controls all DB2 processes and owns all filesystems and devices used by the databases contained within the instance.
    • The default user isdb2inst1and the default group isdb2iadm1.
    Fenced user
    • The fenced user is used to run user defined functions (UDFs) and stored procedures outside of the address space used by the DB2 database.
    • The default user isdb2fenc1and the default group isdb2fadm1.
    DB2 administration server user
    • The user ID for the DB2 administration server user is used to run the DB2 administration server (DAS) on your system.
    • The default user isdasusr1and the default group isdasadm1.
    • This user ID is also used by the DB2 GUI tools to perform administration tasks against the local server database instances and databases.
    • There is only one DAS per computer. One DAS services one or more database instances, including database instances that belong to different installations.
    • The DAS release level must be as high (or higher) than the release level of any of the database instances it services.

The user IDs you create will be required to complete subsequent setup tasks.

Default users and groups

User
Example user name
Example group name
Instance owner
db2inst1
db2iadm1
Fenced user
db2fenc1
db2fadm1
DB2 administration server user
dasusr1
dasadm1
 

Procedure to create uses and groups

To create the required groups and user IDs for DB2 database systems:
  1. Log in as a user with root user authority.
  2. Enter the following commands for the Linux operating systems
a) To create groups
#groupadd -g 999 db2iadm1
#groupadd -g 998 db2fadm1
#groupadd -g 997 dasadm1
 
Ensure that the group-id are not in use, we could use any available group-id
 
b) Create users for each group:
#useradd -u 1004 -g db2iadm1 -m -d /home/db2inst1 db2inst1
#useradd -u 1003 -g db2fadm1 -m -d /home/db2fenc1 db2fenc1
#useradd -u 1002 -g dasadm1 -m -d /home/dasusr1 dasusr1
 
Ensure that the user-id are not in use, we could use any available user-id
 
c) Set initial password:
passwd db2inst1
passwd db2fenc1
passwd dasusr1