PH22431: CM BATCH OBJECT COMPARE NESTED STORED PROCEDURES DROPS WRONG ORDER SQLCODE -478 / SQLCODEN478

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Explicit drops on nested stored procedures are provided in the
  wrong order by compare, even though they are listed in
  the correct order by CM batch.  This may result in a
  SQLCODE -478 / SQLCODEN478 error when the run job is executed:
  
   DSNT408I SQLCODE = -478, ERROR: ALTER, DROP, OR
   REVOKE AFFECTING OBJECT TYPE PROCEDURE CANNOT
   BE PROCESSED BECAUSE OBJECT >procedure name< OF TYPE
   PROCEDURE IS DEPENDENT ON IT
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of Db2 Object Comparison Tool for z/OS *
  *                 who use Change Management and generate       *
  *                 explicit drops on nested stored procedures.  *
  ****************************************************************
  * PROBLEM DESCRIPTION: Explicit drops on nested stored         *
  *                      procedures are generated in the wrong   *
  *                      order by compare even if the drops are  *
  *                      specified in the correct order in the   *
  *                      CM batch job. For multiple nested       *
  *                      stored procedures, the report is        *
  *                      missing information.                    *
  ****************************************************************
  Explicit drops on nested stored procedures are provided in the
  wrong order by compare even though they are mentioned in the
  correct order by CM batch. The explicit drop logic for stored
  procedures does not take into consideration more than one
  level of nesting of stored procedures. The comparison report
  is also missing information for dependent stored procedures
  that are being dropped.
  

Problem conclusion

• The issue 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:

  UI69678

Modules/Macros

• ADB2CM2  ADB2CMF
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RC10 PSY UI69678

     UP20/05/28 P F005

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.