Creating Db2 storage groups

You can create Db2 storage groups by using the CREATE STOGROUP statement. Db2 storage groups are a set of volumes on disks that hold the data sets in which tables and indexes are stored.

Procedure

Begin general-use programming interface information.To create a Db2 storage group:

  1. Issue the SQL statement CREATE STOGROUP.
  2. Specify the storage group name.

    Db2 storage group names are unqualified identifiers of up to 128 characters. A Db2 storage group name cannot be the same as any other storage group name in the Db2 catalog.End general-use programming interface information.

Results

After you define a storage group, Db2 stores information about it in the Db2 catalog. (This catalog is not the same as the integrated catalog facility catalog that describes Db2 VSAM data sets). The catalog table SYSIBM.SYSSTOGROUP has a row for each storage group, and SYSIBM.SYSVOLUMES has a row for each volume. With the proper authorization, you can retrieve the catalog information about Db2 storage groups by using SQL statements.