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

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.

Mandalika

Updated on: 11-Sep-2020

61 Views

Kickstart Your Career

Get certified by completing the course

Get Started