How to create a DB2 storage group STG1 with volume VOL1.

Storage groups are basically the collection of volumes which hold the data that is present in the DB2 table. Basically it is the responsibility of DBA to maintain, add and update the storage groups in DB2.

To create a storage group in a DB2 installation we have to give below command.

CREATE STOGROUP STG1
VOLUMES (VOL1);

The CREATE and STOGROUP are the reserved words which are followed by the name of the storage group. The volume parameter should be populated with the name of the volume for the storage group.

Mandalika

Updated on 11-Sep-2020 12:47:19

• Related Questions & Answers
• How to create a DB2 database DBSET1 in the storage group STG1?
• How to create a DB2 Tablespace in storage group STG1 and bufferpool BP01?
• How to add volume VOL34 and remove volume VOL29 from storage group STG1?
• How to create a DB2 segmented tablespace TABSPAC2 in storage group STOGRP1?
• How to create a DB2 bufferpool with pagesize 4096?
• Create a Button Group with CSS
• Create a Button Group with Bootstrap
• How to create a "button group" with CSS?
• Create a small button group with Bootstrap
• Create a large button group with Bootstrap
• Create a Bordered Button Group with CSS
• Create a Vertical Button Group with CSS
• How to create a vertical "button group" with CSS?
• How to create a scatterplot with colors as group in R?
• How to create JSON format with group-concat in MySQL?