ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.
RC/Migrator strategy to Unload/Load tablespaces with DEFINE NO
Article ID: 145047
RC Compare for DB2 for z/OSDatabase Management for DB2 for z/OS - Administration SuiteEndevor SCM Interface for DB2 for z/OSEndevor SCM Interface for Remote DB2 for z/OSRC/Extract for DB2 for z/OSRC/Migrator for DB2 for z/OSRC/Merger for DB2 for z/OSRC/Query for DB2 for z/OSRC/Secure for DB2 for z/OSRC/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%'