CONVERT TABLESPACE TO NEW TABLESPACE TYPE

Document ID : KB000047941
Last Modified Date : 14/02/2018
Show Technical Document Details

Description:

Example: customer wants to convert all the tablespaces to universal table spaces.

Based on IBM manuals, it requires the following steps:

  1. ALTER TABLESPACE xxxxxxxxx MAXPARTITIONS 1

  2. OLINE TABLESPACE REORG

  3. REBIND INVALID PACKAGES

RC/Migrator can convert the tablespaces using an ALTER strategy to convert a tablespace to a new tablespace type.

Solution:

The RC/Migrator User Guide, Chapter 19 (Tablespaces), provides instructions on how to convert a tablespace to a new tablespace type.

The conversions include the following:

  1. Change Tablespace Type from Simple to Segmented

  2. Change Tablespace Type from Simple to Partitioned

  3. Change Tablespace Type from Simple to Range-Partitioned

  4. Change Tablespace Type from Partitioned to Range-Partitioned

  5. Change Tablespace Type from Segmented to Partitioned

  6. Change Tablespace Type from Segmented to Range-Partitioned

  7. Change Tablespace Type from Partitioned or Segmented to Partition-by-Growth

  8. Change Tablespace Type from Simple to Partition-by-Growth