Filter
Top Products
15.5.1. DMS Table Spaces
Capacity for a DMS table space is the total size of containers allocated to the table space. When a DMS
table space reaches capacity (depending on the usage of the table space, 90% is a possible threshold), you
should add more space to it. The database manager will automatically rebalance the tables in the DMS
table space across all available containers. During rebalancing, data in the table space remains accessible.
A DB2 container may contain more than one physical disk, but a physical disk can be used in only one
DB2 container. We recommend allocating the entire physical disk to a DB2 container and not leaving
over any free space on the physical disk since it will be considered wasted space once the disk is
allocated to the DB2 container.
The DB2 Administration Guide for Implementation states that you can increase the size of a DMS table
space by adding one or more containers to the table space.
To add a container to a DMS table space using the Control Center:
1. Expand the object tree until you see the Table Spaces folder.
2. Right-click the table space you wish to add the container to, and select Alter from the pop-up
menu.
3. Select the Containers tab, click Add, complete the information, and click OK.
4. Click Ok.
To add a container to a DMS table space using the command line, enter:
ALTER TABLESPACE <name> ADD (DEVICE '<path>' <size>)
For example:
ALTER TABLESPACE CFG ADD (DEVICE '/dev/rhd5' 10000)
Note that size is in pages based on the page size of the existing table space you are adding the container
too. In this case, container refers to the DEVICE.
Note that the ALTER TABLESPACE statement allows you to change other properties of the table space
that can affect performance. Refer to “Table Space Impact on Query Optimization” in the Administration
Guide: Performance for more information.
15.5.2. SMS Table Spaces
In general, you cannot extend the size of an SMS table space very easily because SMS capacity depends
on the space available in the filesystem and the maximum size of the file supported by the operating
system. You should be able to increase the size of a filesystem using the normal operating system
facilities for increasing filesystem space.
HPSS Management Guide November 2009
Release 7.3 (Revision 1.0) 366