RC/Migrator strategy to Unload/Load tablespaces with DEFINE NO

Products

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

Issue/Introduction

To create a new environment, need to make an RC/Migrator for Db2 for z/OS (RCM) strategy to unload/load several databases with thousands of tablespaces.
The Unload/Load Jobs do not work completely and the strategy finishes with RC=08 because there are many tablespaces with DEFINE NO.
During unload there is no problem as no data file is created but then when the strategy has to be run the load steps and it finishes with error messages and RC=08.  

Is there an option in RC/Migrator to bypass tablespaces with DEFINE NO.

Resolution

Currently there is not any option in RC/Migrator to bypass tablespaces with DEFINE NO.
 

However you can define two RC/Migrator strategies with the following steps to work in a similar way. 

1. Define a RC/Migrator strategy to migrate the DDL. 
 
2. Define a second RC/Migration strategy to migrate the data, to exclude the empty tablespaces you have to select tables, then include an EQF in
the 'Where ==>' field to select only tablespaces with SPACE > 0. You can work with the following SQL statement in EQF: 
  
AND A.TSNAME IN ( SELECT NAME FROM SYSIBM.SYSTABLESPACE WHERE SPACE > 0 ) AND A.DBNAME LIKE 'DB%'