PI19842: ABEND04E RC00E2000F DSNXOYCU DSNSVSFB OFFSET08EA FROM CREATE FUNCTION SQLPL STATEMENT. OTHER ABENDS AND ERRORS ARE POSSIBLE.

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• ABEND04E RC00E2000F at DSNXOYCU DSNSVSFB OFFSET08EA occurred
  when CREATE FUNCTION SQLPL statement is executed. Other abends
  are possible:
  ABEND0C4 RC00000038 at DSNSLD4 DSNSVSVB OFFSET0B94
  ABEND04E RC00E70005 at DSNXGRDS DSNXGDT2 ERQUALM100 during
  REBIND
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: All DB2 10 for z/OS users of a compiled SQL  *
  *                 scalar function with a RETURN statement that *
  *                 returns an expression which contains special *
  *                 register CURRENT SERVER, CURRENT PACKAGESET  *
  *                 or CURRENT PACKAGE PATH.                     *
  ****************************************************************
  * PROBLEM DESCRIPTION: An ABEND04E RC00E70005 at location      *
  *                      DSNXGRDS DSNXSTRC M777 or other         *
  *                      unexpected ABEND0C4 or ABEND04E         *
  *                      or unexpected SQLCODE -104 during       *
  *                      rebind may occur when a compiled SQL    *
  *                      scalar function contains a RETURN       *
  *                      statement which returns an expression   *
  *                      with special register CURRENT SERVER,   *
  *                      CURRENT PACKAGESET or CURRENT PACKAGE   *
  *                      PATH.                                   *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  The following example helps to illustrate the problem.
  
  CREATE FUNCTION SFUN1(P_NAME VARCHAR(4))
    RETURNS VARCHAR(64)
    LANGUAGE SQL
    DETERMINISTIC
    NO EXTERNAL ACTION
    READS SQL DATA
    INHERIT SPECIAL REGISTERS
    DISABLE DEBUG MODE
    CURRENT DATA NO
    RETURN CASE
             WHEN SUBSTR(P_NAME, 1, 3) = 'TS4'
               THEN P_NAME
             WHEN CURRENT SERVER = 'DR_D2T0'
               THEN '..' !! P_NAME
             ELSE P_NAME
           END?
  
  DB2 does not process the expression of RETURN statement properly
  which can result in storage overlay and parser error during
  rebind.
  

Problem conclusion

• DB2 is modified correctly to process the expression of RETURN
  statement to avoid the problem.
  
  Additional Keywords: DB2OVRLAY/K SQLUDF SQLSPECIALREG
                       SQLCODE104 SQLSTORAGE SQLREBIND
  

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:

  UI20621

Modules/Macros

•    DSNXOYIF DSNXOYTR
  

Fix information

• Fixed component name

  DB2 OS/390 & Z/

• Fixed component ID

  5740XYR00

Applicable component levels

• RA10 PSY UI20621

     UP14/09/03 P F409

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.