Create a DB2 Management Server

When creating a DB2 management server, you can create one or more DB2 management servers. The following describes how to create these two DB2 Management Servers for your reference.

1. Only one DB2 Management Server can be created)

1. Do not create a management service group user first)

Command: sudo groupadd dasadm1

2. Create a user

Command: sudo useradd-g dasadm1-s/bin/bash-m dasusr1

3. Go to the db2 installation directory.

Run the following command in the instance directory:

Create: sudo./dascrt dasusr1
Delete: sudo./dasdrop dasusr1

4. Start and delete a Management Server (das)

Command: su dasusr1 (set the password before logon. Command: sudo passwd dasusr1)
Start: db2admin start
Stop: db2admin stop

2. You can create multiple DB2 Management Server instances)

1. Create group users db2iadm1 and db2fadm1

Command: sudo groupadd db2iadm1
Sudo groupadd db2fadm1

2. Create user db2inst1 and db2fenc1

Command: sudo useradd-g db2iadm1-s/bin/bash-m db2inst1
Sudo useradd-g db2fadm1-s/bin/bash-m db2fenc1

3. Go to the db2 installation directory instance:
Create an instance: sudo./db2icrt-u db2fenc1 db2inst1
Delete instance: sudo./db2idrop db2inst1

4. Start the instance

Su db2inst1
Start: db2start
Stop: db2stop

Several Simple DB2 operation statements

Read stability at the DB2 isolation level

Necessity of Data Warehouse-DB2 query inspection Tool

Provides you with an in-depth understanding of the DB2 data warehouse.

How to query and create a table using DB2