DB2 Version 10.1 for Linux, UNIX, and Windows

Adding containers to SMS table spaces on database partitions

You can add a container to an SMS table space only on a database partition that currently has no containers.

Procedure

To add a container to an SMS table space using the command line, enter the following:

   ALTER TABLESPACE name
      ADD ('path')
      ON DBPARTITIONNUM (database_partition_number)

The database partition specified by number, and every partition in the range of database partitions, must exist in the database partition group on which the table space is defined. A database_partition_number might only appear explicitly or within a range in exactly one db-partitions-clause for the statement.

Example

The following example shows how to add a new container to database partition number 3 of the database partition group used by table space "plans" on a UNIX operating system:

   ALTER TABLESPACE plans
      ADD ('/dev/rhdisk0')
      ON DBPARTITIONNUM (3)