Skip to Content

 

  

Information
Limited support BMC provides limited support for this version of the product. As a result, BMC no longer accepts comments in this space. If you encounter problems with the product version or the space, contact BMC Support.BMC recommends upgrading to the latest version of the product. To see documentation for that version, see ALTER and BMC AMI Change Manager for Db2 13.1.

Conversion of table spaces

Db2 provides several types of table spaces in which you can store various types of data. As your needs change, you might need to change the type of table space that holds your data. ALTER and 

BMC AMI Change Manager for Db2

 enable you to easily convert from one type of table space to another.

The following table shows the supported types of conversions and page references either to instructions for performing the conversions or to more information about the conversion:

From this type

To this type

 

Range-partitioned

Range-partitioned using relative page numbering

(SPE2010)

Partition-by-growth

Nonpartitioned segmented

Supported

Index-controlled partitioned

Supported

Table-controlled partitioned

Supported

Range-partitioned

(SPE2010)

NA

Range-partitioned using relative page numbering

Supported

NA

Supported

Partition-by-growth

Supported

NA


This section contains the following topics:

Related topic

Changes-to-data-structures-via-Specification-component

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*

ALTER and BMC AMI Change Manager for Db2 12.1