RCM: Copying Models, Rulesets or Masksets from one SSID to another

Products

• RC/Migrator for DB2 for z/OS
• RC/Update for DB2 for z/OS

Issue/Introduction

A site may have 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.

Environment

DB2 Tools Release: 19.0 and 20.0

 

Resolution

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 D12A___ USER1  m u D11A <== 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 D12A

 CREATOR  ===>  USER1                     SHARE OPTION ===> U (U,Y,N,X,L)

 SRC SSID ===>   D11A                         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 DVCAUTIL 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 = 'DVCAUTIL'

 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.