Synonyms generated when not selected in the migration strategy.

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

Products

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

Components

  • CA RC/Migrator for DB2 for z/OS:RCM
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

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

{{status}}

Not what you were looking for?

Search Again >

Product Information

Support by Product >

Communities

Join a Community >

Chat with CA

Just give us some brief information and we'll connect you to the right CA ExpertCA sales representative.

Our hours of availability are 8AM - 5PM CST.

All Fields Required

connecting

We're matching your request.

Unfortunately, we can't connect you to an agent. If you are not automatically redirected please click here.

  • {{message.agentProfile.name}} will be helping you today.

    View Profile


  • Transfered to {{message.agentProfile.name}}

    {{message.agentProfile.name}} joined the conversation

    {{message.agentProfile.name}} left the conversation

  • Your chat with {{$storage.chatSession.messages[$index - 1].agentProfile.name}} has ended.
    Thank you for your interest in CA.


    Rate Your Chat Experience.

    {{chat.statusMsg}}

agent is typing