How to template a Compare Rule to another RC/Migrator environment in another LPAR?


Article ID: 131521


Updated On:


CA RC/Migrator CA Endevor SCM Interface DB2 Administration CA RC Compare for DB2 for z/OS CA RC Extract for DB2 for z/OS CA RC/Query CA RC Secure for DB2 for z/OS CA RC Update for DB2 for z/OS CA Database Analyzer for DB2 for z/OS CA Fast Unload for DB2 for z/OS CA Fast Check for DB2 for z/OS CA Fast Index for DB2 for z/OS CA Fast Load for DB2 for z/OS CA Rapid Reorg for DB2 for z/OS


When you create a Compare Rule in a DB2 Subsystem and you want to template to a remote DB2 Susbsytem in another LPAR there is no way to specify the remote DB2 Subsystem as a target. You have to create again manually the Compare Rule in the remote DB2 Subsystem.


Component: RCM


To copy the Compare Rules to another remote DB2 Subsystem in another LPAR you can run the following steps:

- Create a Migration Strategy including the Rule Table PTI.PTMG4_RULES_0300 with a Where clause set in the strategy on columns NAME & CREATOR to only bring over the specific Rule set. You have to create an EQF to select only the Compare Rules to migrate.

To create an EQF you have to work with an Utility Model with Fast Unload/Fast Load utilities.

- Then, run a data only analysis to build the Unload and Load cards.

- Execute this Migration Strategy through Batch Processor making sure the LOAD statement specified RESUME YES.

Basically only one row was unloaded from PTI.PTMG4_RULES_0300 table and the row is loaded to the same table in the target DB2 Subsystem.
If you work with IBM Unload/Load utilities then you cannot work with the EQF to select only one row, anyway you can run same unload but before to load to the target DB2 Subsystem you can manually edit the unloaded data set and delete the Compare Rules that you do not like to load. Normally ther are not so much Compare Rules defined so there should be no problem with the edit.