CONVERT TABLESPACE TO NEW TABLESPACE TYPE using RC/Migrator

Products

• RC/Migrator for DB2 for z/OS
• RC Compare for DB2 for z/OS

Issue/Introduction

To convert Db2 tablespaces to universal table spaces the Db2 Administration Guide requires the following steps:

1. ALTER TABLESPACE xxxxxxxxx MAXPARTITIONS 1
   
   
2. ONLINE TABLESPACE REORG
   
   
3. REBIND INVALID PACKAGES

RC/Migrator for Db2 for z/OS (RCM) can convert the tablespaces using an ALTER strategy to convert a tablespace to a new tablespace type.

Resolution

The RC/Migrator User Guide (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

Convert Multi-Table Tablespaces to Partition-By-Growth Tablespaces

and

Convert Tablespaces Using Compare Strategies

and

Change Tablespace Type to Partition-by-Growth

Additional Information

Tablespace Alter Option