Synonyms generated when not selected in the RC/Migrator migration strategy

Products

• RC/Migrator for DB2 for z/OS

Issue/Introduction

While performing a RC/Migrator for Db2 for z/OS (RCM) Quick Migration, the intent was for Synonyms not to be generated during the Analysis.
The Implode/Explode option of SY (synonym) was set to N and synonyms were still generated in the DDL.

Resolution

There are three possible types of synonyms that can be selected during a migration. The synonyms are for a Base Table (TB S/A), a Materialized Query Table (MQ SY)
or a View (VW SY). All three parameters for synonyms must be set to N to eliminate the DDL from being generated for synonyms.
The selection screen will require that a PF11 key be used to view all the Implode/Explode options.

 

---------------- RC/M Quick Migration Services ---------------- dd/mm/yy hh:mm
COMMAND ===>                                                  SCROLL ===> CSR

SSID   ==> ssid
Object ==>    (SG,DB,TS,TB,MQ,IX,VW,SY,AL,TG,UF,PR,SQ)
Name   ==> TSEMP               > Creator   ==> *         > Where => N

            +--------  OBJECT --------+ +------ IMPLODE/EXPLODE ----------- IMPLODE/EXPLODE -------+
CMD TYPE    NAME               CREATOR  SG DB TS TB(MQ(IX VW SY)) IX VW(MQ(IX VW SY)) S/A SQ TG RT
 _  T       TSEMP              authid1  N  N  N  N  N  N  N  N    N  N  N  N  N  N    N   N  N  N
                                                             |                   |    |
                                                             |                   |    Synonym/Alias for a Table
                                                             |                   |
                                                             |                   Synonym for a View
                                                             |
                                                             Synonym for a MQT

For example:

  DB authid1.DBCORP
    TS DBCORP.TSEMP
      T  authid1.TBEMP
        MQ authid1.MQEMP
          S  authid1.SQEMP   <----A synonym on the Materialized Query Table
          A  authid1.AQEMP   <----An Alias on the Materialized Query Table
        I  authid1.XEMP1
        I  authid1.TBEMPX
        V  authid1.VTEMP
          S  authid1.SVEMP   <----A synonym on the view of the table
          A  authid1.VAEMP   <----An alias on the view
        S  authid1.SYEMP     <----A synonym on the table
        A  authid1.EMPLOYEES <----An alias on the table