PM76826: DB2 OBJECT COMPARISON TOOL FOR Z/OS. VARIOUS CODE CORRECTIONS.

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• DB2 OBJECT COMPARISON TOOL FOR Z/OS. VARIOUS CODE CORRECTIONS.
  PROBLEMS RESOLVED:
  Change of OWNER not detected for inline User Defined
  Function.
  Change of User defined Function OWNER caused change of
  OWNER in dependent Trigger.
  Attempt to delete a Trigger from target before adding Trigger
  for first time.
  Attempt to drop Stored Procedure before dropping dependent
  Stored Procedure
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Object Comparison Tool for  *
  *                 z/OS who compare DB2 Procedures, User        *
  *                 Defined Functions and Triggers.              *
  ****************************************************************
  * PROBLEM DESCRIPTION: This APAR addressed a number of issues: *
  *                                                              *
  *                      1- The OWNER field of a SQL Inline      *
  *                      User Defined Function was not           *
  *                      compared.                               *
  *                                                              *
  *                      2- The OWNER field of a dependent       *
  *                      Trigger was changed when it was         *
  *                      dropped/created to allow a Function     *
  *                      to be changed.                          *
  *                                                              *
  *                      3- A Trigger was dropped from the       *
  *                      target when it should have only         *
  *                      been added.  This caused a              *
  *                      SQLCODE=-204 / SQLCODEN204:             *
  *                                                              *
  *                      DSNT408I SQLCODE = -204, ERROR:         *
  *                      >object< IS AN UNDEFINED NAME           *
  *                      DSNT418I SQLSTATE = 42704               *
  *                      SQLSTATE RETURN CODE                    *
  *                                                              *
  *                      4- A dependent procedure was not        *
  *                      dropped/recreated to allow a            *
  *                      procedure to be changed.  This          *
  *                      caused a SQLCODE=-478 / SQLCODEN478     *
  *                      error:                                  *
  *                                                              *
  *                      DSNT408I SQLCODE = -478,                *
  *                      ERROR: DROP OR REVOKE ON OBJECT         *
  *                      TYPE FUNCTION CANNOT BE PROCESSED       *
  *                      BECAUSE OBJECT >object_name<            *
  *                      OF TYPE TRIGGER IS DEPENDENT ON IT      *
  *                      DSNT418I SQLSTATE   = 42893             *
  *                      SQLSTATE RETURN CODE                    *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  This APAR addressed a number of issues:
  
  1- The OWNER field of a SQL Inline User Defined Function was
  not compared.
  
  2- The OWNER field of a dependent Trigger was changed when it
  was dropped/created to allow a Function to be changed.
  
  3- A Trigger was dropped from the target when it should have
  only been added. This caused a SQLCODE=-204 / SQLCODEN204.
  
  4- A dependent procedure was not dropped/recreated to allow
  a procedure to be changed.  This caused a SQLCODE=-478 /
  SQLCODEN478 error.
  

Problem conclusion

• The problems have 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:

  UK90403 UK90404

Modules/Macros

•    ADB2CMF  ADB2CMP  ADB2CMR  ADB2CMS
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RA10 PSY UK90403

     UP12/12/19 P F212

• RA20 PSY UK90404

     UP12/12/20 P F212

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.