Databases use automatic storage by default
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.