PM63326: DB2 OBJECT COMPARISON TOOL FOR Z/OS MISSING SET CURRENT PATH STATEMENT THAT RESULTS IN SQLCODE -440 WHEN RECREATE UDF

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• DB2 Object Comparison Tool for z/OS missing SET CURRENT PATH
  statement in generated
  WSL that results in SQLCODE -440 (SQLCODEN440) when WSL job runs
  to DROP and recreate UDF
  Additional symptoms:
  sqlerror on CREATE     command, PREPARE    function
   DSNT408I SQLCODE = -440, ERROR:  NO FUNCTION BY THE NAME
  function_name
                  HAVING COMPATIBLE ARGUMENTS WAS FOUND IN THE
  CURRENT PATH
   DSNT418I SQLSTATE   = 42884 SQLSTATE RETURN CODE
   DSNT415I SQLERRP    = DSNXORFN SQL PROCEDURE DETECTING ERROR
   DSNT416I SQLERRD    = -100  0  0  -1  0  0 SQL DIAGNOSTIC
  INFORMATION
   DSNT416I SQLERRD    = X'FFFFFF9C'  X'00000000'  X'00000000'
  X'FFFFFFFF'
            X'00000000'  X'00000000' SQL DIAGNOSTIC INFORMATION
  DSNT416I SQLERRD    = X'FFFFFF9C'  X'00000000'  X'00000000'
  X'FFFFFFFF'
            X'00000000'  X'00000000' SQL DIAGNOSTIC INFORMATION
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Administration Tool for     *
  *                 z/OS who Alter (ALT) the EXTERNAL NAME of    *
  *                 a FUNCTION or STORED PROCEDURE ( SP ).       *
  ****************************************************************
  * PROBLEM DESCRIPTION: When altering a FUNCTION or STORED      *
  *                      PROCEDURE, the EXTERNAL NAME entered    *
  *                      on panel ADBP7F 'Redefine Function' or  *
  *                      panel ADBP7O 'Redefine Procedure' is    *
  *                      truncated causing an ONCODE=350 /       *
  *                      ONCODE350 error:                        *
  *                                                              *
  *                      IBM0361W ONCODE=350  The                *
  *                      STRINGRANGE condition was raised.       *
  *                      From entry point PROC_JAREXTNAME at     *
  *                      statement 18716 at compile unit offset  *
  *                      offset_address at address xxxxxxxx.     *
  *                      From entry point CATREC_STP_OPTIONS at  *
  *                      statement 7774 at compile unit offset   *
  *                      offset_address at address xxxxxxxx.     *
  *                      From entry point CATREC_STP at          *
  *                      statement 6964 at compile unit          *
  *                      offset_address at address xxxxxxxx.     *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  The EXTERNAL NAME generated in the Work Statement List (WSL) is
  truncated causing an ONCODE=350 / ONCODE350 error:
  
  IBM0361W ONCODE=350  The
  STRINGRANGE condition was raised.
           From entry point PROC_JAREXTNAME at
           statement 18716 at compile unit offset
           offset_address at address xxxxxxxx.
           From entry point CATREC_STP_OPTIONS at
           statement 7774 at compile unit offset
           offset_address at address xxxxxxxx.
           From entry point CATREC_STP at statement
           6964 at compile unit offset_address
           at address xxxxxxxx.
  

Problem conclusion

• Problem 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:

  UK81357

Modules/Macros

•    ADBCDTS
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RA10 PSY UK81357

     UP12/08/30 P F208

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.