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

64 Views

Kickstart Your Career

Get certified by completing the course

Get Started