Synonyms generated when not selected in the migration strategy.

Document ID : KB000009406
Last Modified Date : 14/02/2018
Show Technical Document Details
Introduction:

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

Instructions:

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 ---------------- 10/10/20 10:50
COMMAND ===>                                                  SCROLL ===> PAGE
                                                                               
SSID   ==> D91A                                                                
Object ==>  TB  (SG,DB,TS,TB,MQ,IX,VW,SY,AL,TG,RT,SQ)                            
Name   ==> TABLE1            >  Creator   ==> CREATOR1  >  Where => N         
                                                                               
            +---------  OBJECT --------+ +------ 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           TABLE1             CREATOR1  N  N   N   N   N  N   N  N  N  N   N  N   N  N  N  N  N  N         
******************************* BOTTOM OF DATA ********************************
                                                                      |                   |     |     
                                                                      |                   |      Synonym/Alias for a Table
                                                                      Synonym for a MQT      Synonym for a View