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.
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.