PM40216: SQLCODEN478 DROP ON OBJECT TYPE FUNCTION CANNOT BE PROCESSED BECAUSE OBJECT OF TYPE FUNCTION IS DEPENDENT ON IT.

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• The DB2 Object Comparison Tool for z/OS APPLY jobs fails
  with a return code / RC=8 and a message:
  DROP SPECIFIC FUNCTION . ;
  error on DROP command, EXECUTE function
  DSNT408I SQLCODE = -478, ERROR: DROP OR REVOKE ON OBJECT
  TYPE FUNCTION CANNOT BE PROCESSED BECAUSE OBJECT
  OF TYPE FUNCTION IS DEPENDENT ON IT
  DSNT418I SQLSTATE = 42893 SQLSTATE RETURN CODE
  DSNT415I SQLERRP = DSNXIDRT SQL PROCEDURE DETECTING ERROR
  DSNT416I SQLERRD    = 30  0  0  -1  0  0 SQL DIAGNOSTIC
  INFORMATION
  DSNT416I SQLERRD    = X'0000001E'  X'00000000'  X'00000000'
  X'FFFFFFFF'
           X'00000000'  X'00000000' SQL DIAGNOSTIC INFORMATION
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Object Comparison Tool for  *
  *                 z/OS who change DB2 functions.               *
  ****************************************************************
  * PROBLEM DESCRIPTION: A DROP of a function may fail with      *
  *                      SQLCODE=-478 / SQLCODEN478:             *
  *                                                              *
  *                      DSNT408I SQLCODE = -478,                *
  *                      ERROR: DROP OR REVOKE ON                *
  *                      OBJECT TYPE FUNCTION                    *
  *                      CANNOT BE PROCESSED                     *
  *                      BECAUSE OBJECT OF TYPE                  *
  *                      FUNCTION IS DEPENDENT ON IT             *
  *                      DSNT418I SQLSTATE = 42893               *
  *                      SQLSTATE RETURN CODE                    *
  *                                                              *
  *                      if another function depends upon        *
  *                      the function being dropped. A           *
  *                      CREATE of a function may fail with      *
  *                      a SQLCODE=-440 / SQLCODEN440:           *
  *                                                              *
  *                      SQLCODE=-440 NO routine-type BY         *
  *                      THE NAME routine-name HAVING            *
  *                      COMPATIBLE ARGUMENTS WAS                *
  *                      FOUND IN THE CURRENT PATH               *
  *                                                              *
  *                      if the function being created depends   *
  *                      on a function that does not exist.      *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  The DB2 Object Comparison Tool does not recognize the
  interdependency of functions when a DROP or CREATE is
  attempted.  Functions are dropped and created in alphabetical
  order instead of function dependency order.
  

Problem conclusion

• The DB2 Object Comparison Tool has been corrected.  Functions
  that depend on a function being dropped will be dropped first.
  Functions being created will be created in the order of
  dependency. This implementation requires version files created
  from DB2 catalog information.  If the source changes the
  dependency order of the functions, it must be from catalog
  information.  If the source only modifies function parameters
  or options, it can be from DDL information.
  

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:

  UK78295

Modules/Macros

•    ADB2CMF  ADB2CMP  ADB2CMR  ADB2CMS  ADB2CMT
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RA10 PSY UK78295

     UP12/04/28 P F204

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.