Use the CREATE STOGROUP statement to create storage groups.
Creating a storage group within a database assigns storage paths to
the storage group.
Before you begin
If you create a database with the
AUTOMATIC STORAGE
NO clause it does not have a default storage group. You can
use the CREATE STOGROUP statement to create a default storage group.
Note: Although,
you can create a database specifying the AUTOMATIC STORAGE NO clause,
the AUTOMATIC STORAGE clause is deprecated and might be removed from
a future release.
Procedure
To create a storage group by using the command line, enter
the following statement: CREATE STOGROUP operational_sg ON '/filesystem1', '/filesystem2', '/filesystem3'...
where
operational_sg is the name
of the storage group and
/filesystem1,
/filesystem2,
/filesystem3 ,
... are the storage paths to be added.
Important: To help
ensure predictable performance, all the paths that you assign to a
storage group should have the same media characteristics: latency,
device read rate, and size.
DB2 Version 10.1 for Linux, UNIX, and Windows