PM26687: COMPARE OF VIEW WITH 2 SYNONYMS GENERATES THE SAME CREATOR FOR 2ND SYNONYM RESULTING IN ANALYZE ERROR OR SQLCODE -601

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• In the DB2 Administration Tool for z/OS, when a comparison is
  performed on a View which has 2 synonyms, a generated change
  for the 2nd synonym contains the same SQLID as the 1st synonym.
  
  Change Management's Analyze with VALIDATE=YES fails on
  the validate step.
  
  Change Management's Run fails with a -601 if VALIDATE=NO.
  SYMPTOM: SQLCODEN601.
  

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:

  UK66735

Modules/Macros

• ADB2CMF
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RA10 PSY UK66735

     UP11/04/15 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.