Altering table spaces

Use the ALTER TABLESPACE statement to change the description of a table space at the current server.

About this task

Pending definition changes are changes that are not immediately materialized. For detailed information about pending definition changes, how to materialize them, and related restrictions, see Pending data definition changes

Immediate definition changes are changes that are materialized immediately. Most immediate definition changes are restricted while pending definition changes exist for an object. For a list of such restrictions, see Restrictions for changes to objects that have pending data definition changes.

To alter table spaces, use any of the following approaches:

• Issue ALTER TABLESPACE statements from embedded application programs or interactively.
• Use the ALTER TABLESPACE statements to change the table space type and attributes, or to enable or disable MEMBER CLUSTER.
• Use the MAXPARTITIONS attribute of the ALTER TABLESPACE statement to change the maximum partition size for partition-by-growth table spaces. You can use this attribute to convert a simple table space, or a single-table segmented (non-universal) table space to a partition-by-growth universal table space.
• Use the SEGSIZE attribute of the ALTER TABLESPACE statement to convert a partitioned table space to a range-partitioned universal table space.

What to do next

You can use the DROP PENDING CHANGES clause to drop all pending definition changes for the table space and for any of the objects in the table space.