Automatic storage can make storage management easier. Rather
than managing storage at the table space level using explicit container
definitions, storage is managed at the storage group level and the
responsibility of creating, extending and adding containers is taken
over by the database manager.
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.
By default, all databases
are created with automatic storage. However, if the database is created
specifying the AUTOMATIC STORAGE NO clause it cannot use automatic
storage managed table spaces. When you create a database, by default, a default storage group
is automatically created. You can establish one or more initial storage
paths for it. As a database grows, the database manager creates containers
across those storage paths, and extends them or automatically creates
new ones as needed. The list of storage paths can be displayed using
the ADMIN_GET_STORAGE_PATHS administrative view.
If a database has no storage groups, you can create a storage group
using the CREATE STOGROUP statement. The newly created storage group
is the default storage group and all new automatic storage managed
table spaces are added to the database using this storage group. You
can change the default storage group using the SET AS DEFAULT clause
of the CREATE STOGROUP statement or the ALTER STOGROUP statement.
Important: - Adding storage paths does not convert existing non-automatic storage
table spaces to use automatic storage. You can convert database managed
(DMS) table spaces to use automatic storage. System managed (SMS)
table spaces cannot be converted to automatic storage. See Converting table spaces to use automatic storage for more information.
- Once a database has storage groups created, it always has at least
one storage group. You cannot remove the last storage group from the
database manger.
- To help ensure predictable performance, the storage paths added
to a storage group should have similar media characteristics.
DB2 10.5 for Linux, UNIX, and Windows