PM06979: SYNONYMS FOR VIEWS ARE NOT RECREATED WITH THE RIGHT SQLID. FFA10 PM28154.

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• In DB2 Object Comparison Tool, when comparing TABLES with VIEWS
  and VIEWS have more than 1 synonym, SQLID used to recreate the
  SYNONYMS is wrong, resulting in SQLCODE = -601 when running
  the APPLY job.
  Additional Symptoms: sqlcode601
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Object Comparison Tool for  *
  *                 z/OS who compare synonyms on a view which    *
  *                 are on the target and not on the source.     *
  ****************************************************************
  * PROBLEM DESCRIPTION: When Object Compare with KEEPTGT and    *
  *                      CMDELTA options compares synonyms on a  *
  *                      view (more than one synonym on view)    *
  *                      and the synonyms are on target only,    *
  *                      the SQLID (synonym creator) is set      *
  *                      incorrectly resulting in a              *
  *                      SQLCODE=-601/SQLCODEN601 when running   *
  *                      the apply job:                          *
  *                                                              *
  *                      SQLCODE =-601                           *
  *                      THE NAME (VERSION OR VOLUME             *
  *                      SERIAL NUMBER) OF THE OBJECT            *
  *                      TO BE DEFINED OR THE TARGET             *
  *                      OF A RENAME STATEMENT IS                *
  *                      IDENTICAL TO THE EXISTING NAME          *
  *                      (VERSION OR VOLUME SERIAL               *
  *                      NUMBER) object-name OF THE              *
  *                      OBJECT TYPE object-type                 *
  *                                                              *
  *                      SQLSTATE 42710                          *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  When Object Compare with KEEPTGT and CMDELTA options compares
  synonyms on a view (more than one synonym on view) and the
  synonyms are on target only, the SQLID (synonym creator) is set
  incorrectly resulting in a SQLCODE= -601/SQLCODEN601 when
  running the apply job.
  

Problem conclusion

• The problem has been resolved.
  

Temporary fix

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

  UK67032

Modules/Macros

•    GOC2CMF
  

Fix information

• Fixed component name

  DB2 OBJECT COMP

• Fixed component ID

  5697G6400

Applicable component levels

• R720 PSY UK67032

     UP11/04/27 P F104

Fix is available

• Select the PTF appropriate for your component level. You will be required to sign in. Distribution on physical media is not available in all countries.