A site may have RC/Migrator for Db2 for z/OS (RCM) Utility Models that have been customized, or Compare Rulesets and Masksets they would
like to copy to another subsystem. This avoids having to create them from scratch on the Target subsystem.
This can be done using a Data Only Migration from the related tables.
The process below can be used on the following tables:
Utility Models : PTMOD_UTLSYM_0401
Ruleset: PTMG4_RULES_0300
Maskset: PTMG9_MASK_0510
This example will use the Model Table
1. Create a Migration Strategy at the Table level (PTI.PTMOD_UTLSYM_0401), include the Index.
T S SRC +---- LAST UPDATE ----+
O STRATEGY DESCRIPTION CREATOR P O SSID USER DATE TIME
C MIGMODL2 Migrate Models to ssid____ USER1 m u ssid <== STRATEGY CREATION
----
PRIMARY OBJECT TYPE SPECIFICATION. ( Select one type with 'A' , 'S', or 'E' )
_ Storage Group
_ Database
_ Tablespace
s Table
_ Materialized Query Table
_ Index
_ View
_ Synonym/Alias
_ Trigger
_ Routine
_ Sequence
PRIMARY OBJECT SELECTION SPECIFICATION.
Name ==> PTMOD_UTLSYM_0401 > Creator ==> PTI > Where ==> N
On the Implode/Explode Services place an 'A' under IX.
2. Use a Data query to select certain Models, on the Implode/Explode Services, scroll to the right place a 'Y' and Query Name under the 'WHERE'.
The Data Query Edit screen is shown. Enter a Query to select the Model ID's and /or creators to be migrated, use wildcards if needed. (optional)
RMPLTB1 20.0 --------- RC/M Implode/Explode Services -------- 19/07/31 10:20
COMMAND ===> SCROLL ===> PAGE
STRATEGY ===> MIGMODL2 DESCRIPTION ===> MIGRATE MODELS TO ssid
CREATOR ===> USER1 SHARE OPTION ===> U (U,Y,N,X,L)
SRC SSID ===> ssid NEW OBJECTS ===> N (U,Y,N)
------------------------------------------------------------------ USER1 < >
+ >-EXPL OPT-+ AUX RTN MQT SEQ SECU ALL NUMBER
S A TG IMP IMP IMP IMP RI RITY ROWS OF ROWS WHERE
_ _ _ _ _ _ _ _ _ _ ________ Y Datqry__
Press ENTER: Filter as needed, this is choosing 1 model named IMCAUTIL to migrate.
Query Name ==> DATQRY For Table: PTI.PTMOD_UTLSYM_0401 >
Description ==> > Share ==> Y Default ==> N
Confirm Replace ==> Y Auto Cast ==> Y View SQL ==> N
Test Count ==> N Shrink ==> N Row Limit ==> Userid: USER1
Sel C Ord Column Name Type ----------- Where Condition ------- AND
S __ 1 MODEL_ID C(8)
S __ 2 MODEL_CREATOR C(8)
S __ 3 MODEL_PRODUCT_CODE C(3)
S __ 4 SEQUENCE_FIELD SMALLI>
S __ 5 INTERNAL_TYPE SMALLI>
S __ 6 DATA V(4022)
******************************* BOTTOM OF DATA ********************************
Extended Where:
01 and MODEL_ID = 'IMCAUTIL'
02
3. Analyze the Strategy, place a 'Y' by 'Update Options'
Specify Data Only:
BND/DAT/STA/SQL/GRNT/RI ==> D
Specify ALL ROWS Y:
ALL ROWS ==> Y
4. The resulting Analysis will contain an UNLOAD from the Source with a WHERE condition if a Data Query was used, and a LOAD to the Target.
If no Data Query was used the whole table will be unloaded/loaded to the Target.
Confirm the Model, Ruleset or Maskset now exists on the target ssid.