---

DB2 Create Database 

Make DATABASE order is utilized to make a database in an example. All databases are made with the default stockpiling bunch "IBMSTOGROUP", which is made at the hour of making a case. 

In DB2, all the database tables are put away in "tablespace", which utilize their separate stockpiling gatherings. 

Create Non-restrictive Database

db2 make database order is utilized to make a non-prohibitive database. 

Syntax:

db2 create database <database name>  

Example:

let's create a database named "XYZ"  

After establishment, you need to change to that client to have rights to make another database. Contingent upon the form you introduced, that username may be changed. Be that as it may, DB2 utilizes db2inst1 naturally as director client. 

Check your/home registry. You will see another user(most presumably db2inst1). At that point change to that client with: 

su - db2inst1  

at that point issue: 

db2 CREATE DATABASE XYZ  

Creating restrictive database

A prohibitive database can be made by utilizing the accompanying order: 

db2 create database <db_name> restrictive  

How about we make a prohibitive database named "XYZ2"