For DMS table spaces, you can add, extend, rebalance, resize,
drop, or reduce containers.
Adding DMS containers
You can increase the size of a DMS table space (that is,
one created with the MANAGED BY DATABASE clause) by adding one or
more containers to the table space.
Dropping DMS containers
With a DMS table space, you can drop a container from the
table space using the ALTER TABLESPACE statement.
Resizing DMS containers
Containers in a database managed (DMS) table
space can be resized as storage needs change. If you use the auto-resize
capabilities for DMS containers, the database manager handles this
for you. If you did not enable the auto-resize option, you can also
make adjustments manually.
Rebalancing DMS containers
The process of rebalancing involves moving
table space extents from one location to another, and it is done
in an attempt to keep data striped within the table space. You typically
rebalance a table space when adding storage paths to or dropping storage
paths from a database.
Reclaiming unused storage in DMS table spaces
You can reclaim unused storage in a DMS table space by
telling the database manager to consolidate in-use extents lower in
the table space. This also has the effect of lowering the high water
mark. To reduce the container sizes in a DMS table space requires
a separate REDUCE operation must also be performed.
Prefetch size adjustment when adding or dropping containers
The default size for all prefetches from disk
is set automatically for any table spaces created using DB2® versions
8.2 and later. This means that the database manager calculates a suitable
prefetch size based on several factors, including the extent size,
the number of containers in your table space, and the properties of
your storage devices.
Converting table spaces to use automatic storage
You can convert some or all of your database-managed space
(DMS) table spaces in a database to use automatic storage. Using automatic
storage simplifies your storage management tasks.