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

book

Article ID: 145047

calendar_today

Updated On:

Products

CA RC Compare for DB2 for z/OS CA Database Management for DB2 for z/OS - Administration Suite CA Endevor SCM Interface for DB2 for z/OS CA Endevor SCM Interface for Remote DB2 for z/OS CA RC/Extract for DB2 for z/OS CA RC/Migrator for DB2 for z/OS CA RC/Merger for DB2 for z/OS CA RC/Query for DB2 for z/OS CA RC/Secure for DB2 for z/OS CA RC/Update for DB2 for z/OS

Issue/Introduction

To create a new environment, I need to make an RC/Migrator strategy to unload/load several databases with thousands of tablespaces.
The Unload/Load Jobs do not work completely and 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?. 

Environment

Release : 20.0

Component : CA RC/Migrator for DB2 for z/OS

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%'