PM28154: OBJECT COMPARE WITH KEEPTGT AND CMDELTA OPTIONS COMPARES SYNONYMS ON A VIEW AND SQLID (SYNONYM CREATOR) IS INCORRECT.

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error 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
  

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.
  
  DDL reader is changed to take synonyms creator from the SQLID
  instead of SCHEMA.
  

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:

  UK67034

Modules/Macros

•    ADBCDTS
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RA10 PSY UK67033

     UP11/04/27 P F104

• R720 PSY UK67034

     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.