PI44576: DB2 ADMINISTRATION TOOL FOR Z/OS ISSUES SQLCODE -601 SQLCODEN601 WHILE RUNNING A CHANGE WITH CREATE VIEW

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• DB2 Administration Tool for z/OS issues SQLCODE -601
  SQLCODEN601 while running a CHANGE with create view
  when a SYNONYM exists
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Administration Tool         *
  *                 for z/OS who use compare with Change         *
  *                 Management (CM) and register a delta         *
  *                 change.                                      *
  ****************************************************************
  * PROBLEM DESCRIPTION: DB2 Admin issues a SQLCODE=-601 /       *
  *                      SQLCODEN601 when running a change       *
  *                      to create a view when a SYNONYM         *
  *                      exists:                                 *
  *                                                              *
  *                      DSNT408I SQLCODE = -601, ERROR:         *
  *                      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        *
  *                      SYNONYM                                 *
  *                      DSNT418I SQLSTATE   = 42710             *
  *                      SQLSTATE RETURN CODE                    *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  Program does not return Return Code 8 / RC 8 with an error
  message when detecting duplicate names on a target after
  compare.
  

Problem conclusion

• Problem has been resolved.
  
  The following new messages have been added:
  
  ADB7176E
  Synonym syn_name for syn_creator is also found as an
  obj_type
  
  Explanation
  The name of the synonym has already been found as
  another obj_type in the target.
  
  System action
  Processing stops.
  
  User response
  Refer to the compare report to correct this error and rerun
  the job.
  
  ADB7177E
  Obj_type obj_creator.obj_name is also found as an
  obj_type.
  
  Explanation
  Obj_type obj_creator.obj_name has already been found
  as another obj_type in the target.
  
  System action
  Processing stops.
  
  User response
  Refer to the compare report to correct this error and rerun
  the job.
  
  and will be displayed when detecting duplicate names on
  a target after performing a compare.
  

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:

Modules/Macros

• ADB2CMP  ADB7000
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RA20 PSY UI31745

     UP15/10/06 P F510

• RB10 PSY UI31746

     UP15/10/06 P F510

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.