Is there an easy way to propagate RC/Migrator for Db2 for z/OS (RCM) migrations to multiple targets.
A Group Analysis of a Migration Strategy utilizes Copy Group services to facilitate migrations to multiple targets within a single analysis.
Here are the necessary steps:
Execute the 'Group Analysis'
From the RC/Migrator (RCM) Strategy Services enter a 'G' line command to the left of the migration strategy in order to execute the Group Migration Strategy Analysis.
RMS1 -------------- RC/M Strategy Services -------------- yy/mm/dd hh:mm
COMMAND ===> SCROLL ===> CSR
DB2 SSID ===> ssid
STRATEGY ===> EMP CREATOR ===> authid1 TYPE ===> M SRC SSID ===> *
--------------------------------------------------------------------- authid1
T S SRC +---- LAST UPDATE ----+
O STRATEGY DESCRIPTION CREATOR P O SSID USER DATE TIME
_ ________ _________________________ authid1 _ N ____ <== STRATEGY CREATION
G EMP EMP authid1 M U ssid authid1 yy/mm/dd hh:mm
******************************** BOTTOM OF DATA *******************************
Select a Copy Group and other analysis options:
Group Migrations require the use of Copy Groups. A Copy Group consists of 1 or more Copy IDs that specify target information including Target SSID, Global Changes and Utility Specifications. In Group Migrations, the target SSID is defined for each Copy ID in a Copy Group set; the Target SSID field on the RC/M Group Migration Strategy Analysis screen is ignored but must be specified. In a Group Migration, global changes can be specified for each Copy ID in a Copy Group set; all specifications apply. Global changes specified on the Analysis screen (not in the copy group set member), are appended to each copy group set member's global change set in the copy group set. The first global change specification that can be applied to an object is used.
From the Group Migration Strategy Analysis screen, Copy Group settings can be defined by entering an 'S' (Select) in the Copy Group field under COPY GROUP SPECIFICATIONS, allowing access to the RC/M Copy Group Services screen where Copy Groups can be selected, created, updated, tem plated, deleted or browsed.
RMA3G ----- RC/M Group Migration Strategy Analysis ----- yy/mm/dd hh:mm
COMMAND ===>
STRATEGY ===> EMP DESCRIPTION ===> EMP
CREATOR ===> authid1 SHAREOPTION ===> U
--------------------------------------------------------------------- authid1
EXECUTION SPECIFICATIONS ACCESS SPECIFICATIONS
EXECUTION MODE ===> ( O - Online, B - Batch ) ACM ANALYSIS ===> N
OVERRIDE ===> N PDS ANALYSIS ===> N
RECOVERY ===> N
DB2 SSID SPECIFICATIONS
OPTION SPECIFICATIONS SOURCE SSID ===> ssid
UPDATE OPTIONS ===> N TARGET SSID ===> ssid
PROFILE NAME ===>
PROFILE CREATOR ===>
GLOBAL CHANGES ===> N
SET NAME ===> COPY GROUP SPECIFICATIONS
SET CREATOR ===> COPY GROUP ===> s
GROUP NAME ===>
OUTPUT ANALYSIS SPECIFICATIONS GROUP CREATOR ===>
EDIT OUTPUT ===> N ANALYSIS USER ===> authid1
STRATEGY ===> EMP ANALYSIS DATE ===> N/A
CREATOR ===> authid1 ANALYSIS TIME ===> N/A
COMMENT ===>
RMCG1 ------------- RC/M Copy Group Services ------------ yy/mm/dd hh:mm
COMMAND ===> SCROLL ===> CSR
RM288 RM288I: Please select a Copy Group for this analysis.
GROUP SSID ===> ssid
GROUP NAME ===> EMPCG CREATOR ===> *
--------------------------------------------------------------------- Authid1
S +---- LAST UPDATE -----+
O GROUPNAME DESCRIPTION CREATOR O USER DATE TIME
_ ________ _________________________ Authid1 N <== GROUP SET CREATION
U EMPCG EMP COPY GROUP Authid1 U Authid1 yy/mm/dd hh:mm
Update the copy group.
RMCG3 -------------- RC/M Copy Group Update ------------- yy/mm/dd hh:mm
COMMAND ===> SCROLL ===> CSR
Groupname ===> EMPCG Description ===> EMP COPY GROUP
Creator ===> authid1 Share Option ===> U (U,Y,N)
--------------------------------------------------------------------- authid1
GLOBAL GLOBAL-CHANGE-SET TRG UTILITY
O NUM COPY-ID DESCRIPTION CHANGES CREATOR NAME SSID OPTIONS
_ 1 1 _________________________ N ________ ________ ssn1 N
_ 2 2 _________________________ N ________ ________ ssn2 N
_ 3 3 _________________________ N ________ ________ ssn3 N
This copy group is targeting three subsystems. If more changes are needed each one above can have an attached Global change set.
RMA3G ----- RC/M Group Migration Strategy Analysis ----- yy/mm/dd hh:mm
COMMAND ===>
RM276 RM276I: Copy Group selections have been set. Press HELP for more info
STRATEGY ===> EMP DESCRIPTION ===> EMP
CREATOR ===> authid1 SHAREOPTION ===> U
--------------------------------------------------------------------- authid1
EXECUTION SPECIFICATIONS ACCESS SPECIFICATIONS
EXECUTION MODE ===> ( O - Online, B - Batch ) ACM ANALYSIS ===> N
OVERRIDE ===> N PDS ANALYSIS ===> N
RECOVERY ===> N
DB2 SSID SPECIFICATIONS
OPTION SPECIFICATIONS SOURCE SSID ===> ssid
UPDATE OPTIONS ===> N TARGET SSID ===> ssid
PROFILE NAME ===>
PROFILE CREATOR ===>
GLOBAL CHANGES ===> N
SET NAME ===> COPY GROUP SPECIFICATIONS
SET CREATOR ===> COPY GROUP ===> Y
GROUP NAME ===> EMPCG
OUTPUT ANALYSIS SPECIFICATIONS GROUP CREATOR ===> authid1
EDIT OUTPUT ===> N ANALYSIS USER ===> authid1
STRATEGY ===> EMP ANALYSIS DATE ===> N/A
CREATOR ===> authid1 ANALYSIS TIME ===> N/A
COMMENT ===>
Choose Online or Batch Execution Mode to submit the analysis.
RMS1 -------------- RC/M Strategy Services -------------- yy/mm/dd hh:mm
COMMAND ===> SCROLL ===> CSR
DB2 SSID ===> ssid
STRATEGY ===> EMP CREATOR ===> authid1 TYPE ===> M SRC SSID ===> *
--------------------------------------------------------------------- authid1
T S SRC +---- LAST UPDATE ----+
O STRATEGY DESCRIPTION CREATOR P O SSID USER DATE TIME
_ ________ _________________________ authid1 _ N ____ <== STRATEGY CREATION
_ EMP EMP authid1 M U ssid authid1 yy/mm/dd hh:mm
_ CGRP * MANAGED OUTPUT * (EMP1) authid1 yy/mm/dd hh:mm
_ CGRP * MANAGED OUTPUT * (EMP2) authid1 yy/mm/dd hh:mm
_ CGRP * MANAGED OUTPUT * (EMP3) authid1 yy/mm/dd hh:mm
_ authid1.HLQ1.BPCODE(EMP1) authid1 yy/mm/dd hh:mm
_ authid1.HLQ1.BPCODE(EMP2) authid1 yy/mm/dd hh:mm
_ authid1.HLQ1.BPCODE(EMP3) authid1 yy/mm/dd hh:mm
The first analysis above uses Managed Output(first three lines) and a second analysis using output to a PDS dataset (second three lines).
Each one of the analysis outputs above targets the subsystems identified in the COPY GROUP defined and all generated in one analysis job and individual output for each Copy Group member.
Execute the DDL
From the RC/Migrator Strategy Services screen, execute the DDL (now listed under the Migration Strategy) by entering an 'S' (submit) to the left of the DDL analysis row above.