PM31997: ORDER OF DEPENDENT OBJECTS IN GEN OUTPUT RESULTS IN SQLCODE440

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• The DB2 Administration Tool for z/OS GEN function creates DDL
  in which the order of objects does not reflect the order that
  they need to be created in to prevent a SQLCODE440 being issued.
  

Local fix

• Manually reorder the DDL such that called functions/procedures
  are created before they are referenced by other procedures.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Object Comparison Tool for  *
  *                 z/OS who reference Native Stored Procedures  *
  *                 (NSP) that specify the VALIDATE BIND         *
  *                 option.                                      *
  ****************************************************************
  * PROBLEM DESCRIPTION: The DB2 Object Comparison Tool,         *
  *                      creates Native Stored Procedure         *
  *                      without checking for dependent          *
  *                      objects.                                *
  *                                                              *
  *                      If the NSP have VALIDATE BIND coded,    *
  *                      the CREATE will fail with a             *
  *                      SQLCODE=-440 / SQLCODEN440:             *
  *                                                              *
  *                      DSNT408I SQLCODE = -440, ERROR:         *
  *                      NO PROCEDURE BY THE NAME                *
  *                      procedure_name HAVING COMPATIBLE        *
  *                      ARGUMENTS WAS FOUND IN THE              *
  *                      CURRENT PATH                            *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  The DB2 Object Comparison Tool creates NSP's alphabetically.
  

Problem conclusion

• The DB2 Object Comparison Tool has been changed to create all
  NSP's with the VALIDATE RUN option and once all of the NSP's
  have been created, then issue the ALTER VALIDATE BIND
  statements for those NSP's originally defined as VALIDATE
  BIND.
  

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:

  UK77178

Modules/Macros

•    ADB2CMP  ADB2CMR  ADB2CMS
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RA10 PSY UK77178

     UP12/03/25 P F203

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.