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

DB2DatabaseBig Data Analytics

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.

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

Advertisements