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.
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
S authid1.SQEMP <----A synonym on the Materialized Query Table
A authid1.AQEMP <----An Alias on the Materialized Query Table
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