RC/Migrator strategy to Unload/Load tablespaces with DEFINE NO
Article ID: 145047
CA RC Compare for DB2 for z/OSCA Database Management for DB2 for z/OS - Administration SuiteCA Endevor SCM Interface for DB2 for z/OSCA Endevor SCM Interface for Remote DB2 for z/OSCA RC/Extract for DB2 for z/OSCA RC/Migrator for DB2 for z/OSCA RC/Merger for DB2 for z/OSCA RC/Query for DB2 for z/OSCA RC/Secure for DB2 for z/OSCA RC/Update for DB2 for z/OS
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?.
Release : 20.0
Component : CA RC/Migrator for DB2 for z/OS
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%'