Synonyms generated when not selected in the migration strategy.

Document ID:  TEC533309
Last Modified Date:  07/04/2017
{{active ? 'Hide' : 'Show'}} Technical Document Details


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


  • CA RC/Migrator for DB2 for z/OS:RCM

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.


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

Please help us improve!

Will this information enable you to resolve your issue?

Please tell us what we can do better.

{{feedbackText.length ? feedbackText.length : '0'}}/255


Not what you were looking for?

Search Again >

Product Information

Support by Product >


Join a Community >