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 | Partition-by-growth | |
Nonpartitioned segmented | Supported | ||
Index-controlled partitioned | Supported | ||
Table-controlled partitioned | Supported | ||
Range-partitioned | NA | ||
Range-partitioned using relative page numbering | Supported | NA | Supported |
Partition-by-growth | Supported | NA | |
This section contains the following topics: