DB2 Users and Groups

-

 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.

 

Default users and groups

User

Sample User Name

Sample Group Name

Instance User

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:

Log in as a user with root user authority.

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

 

Comments

Post a Comment

Popular posts from this blog

Db2 export command example using file format (del , ixf)

-
You want to transfer data from a db2 database table to another db2 database or within the same database, one of the way is to use db2 export / import command. Using db2 export / import you can move your data to excel also.   DB2 export command exports data selected by SQL statement from a table or view to an external files in the format of  del - delimited , wsf - worksheet format , ixf - Integration Exchange Format,asc.   The DEL format uses delimiter and column separator and decimal point. The default string delimiter is double quote " and column separator is comma(,) and Decimal Point is dot(.), you can also specify your own string delimiter & column separator, decimal point. Another format supported by DB2 is   IXF (Integration Exchange Format). It is a generic relational database exchange format which supports an end-of-record delimiter . IXF architecture supports to exchange of relational database structures and data. IXF is used for transferring data ...
Read more

How to fix DB2 Tablespace OFFLINE state issue?

-
Sometimes we face an error where one (or more) of our db2 tablespaces goes offline caused by loads, DB crashes, abnormal db2 services/or server shutdown, etc. So in this blogpost let us see how can we check which tablespace is in OFFLINE state and bring back tablespace’s state to ONLINE.   Finding TableSpace State To check which tablespace is OFFLINE, execute the below command: SYNTAX: db2 connect to <database_name> db2 list tablespaces |egrep -i "ID|Name|State" db2 list tablespaces show detail   If u see Tablespace state with 0x4000, then that tablespace is in Offline state There are 2 methods to resolve the tablespace from offline to online as below. Method1: We can execute below DB2 commands to take off tablespace's OFFLINE state.   db2 terminate db2 force application all db2 connect to <database_name>   Method 2:  Perform ALTER Tablespace command to bring the tablespace up while the rest of the database is still up...
Read more

Phases of a load operation

-
A complete load operation consists of five distinct phases; they are as follows: Analyze phase Load phase Build phase Delete phase Index copy phase Analyze phase:  This phase of the Load process is only utilized when a column-organized table is being loaded and the column compression dictionaries need to be built. This happens during a LOAD REPLACE operation, a LOAD REPLACE RESETDICTIONARY operation, a LOAD REPLACE RESETDICTIONARYONLY operation, or a LOAD INSERT operation (if the column-organized table is empty). For column-organized tables, this phase is followed by the load, build, and delete phases. The following diagram showcases the steps involved in the analyze phase. The analyze phase is invoked if you are loading data for the first time into a column-organized BLU acceleration table using LOAD INSERT, or running a LOAD REPLACE with RESETDICTIONARY or RESETDICTIONARYONLY clause. Load phase:  During this phase, data is loaded into the table, and index keys and table stat...
Read more