How to create a DB2 database DBSET1 in the storage group STG1?

DB2DatabaseBig Data Analytics

A database is a structured collection of data which can be organized, maintained and updated easily. There can be multiple databases in a DB2 installation. The DB2 database can be created by giving the name of the database, storage group and bufferpool, as below−

CREATE DATABASE DBSET1
      STOGROUP (STG1)
   BUFFERPOOL BP3;

The CREATE and DATABASE are the reserved words which are followed by the name of the database we want to create. The STOGROUP parameter should be given with the name of the storage group and finally BUFFERPOOL parameter followed by the name of bufferpool.

raja
Published on 11-Sep-2020 12:51:47
Advertisements