How to exclude base table when only the archive table needs to be migrated executing RC/Migrator
search cancel

How to exclude base table when only the archive table needs to be migrated executing RC/Migrator

book

Article ID: 125577

calendar_today

Updated On:

Products

RC/Migrator for DB2 for z/OS

Issue/Introduction

When a RC/Migrator for Db2 for z/OS (RCM) strategy is created with only archive table spaces or tables, expect only the archive table spaces or tables included
in the strategy. When the strategy is analyzed the base tables are also included.

Resolution

To exclude the base table you have to proceed with the following steps.

Update the current Migrator strategy, when in panel 'RC/M Implode/Explode Services', change the option under 'TB' (Table) from 'A' to 'S' and hit Enter.

This will take you to the panel 'RC/M Dependent Table Selection'. Then use option 'L' to list table associations, the archive and base table will be listed.
Select the archive table and hit PF3. PF3 again until you save the Migration strategy.
 
On this way the base table will be excluded during the analysis of the strategy.