IBM Support

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

A fix is available

Subscribe

You can track all active APARs for this component.

 

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 number

    PI19842

  • Reported component name

    DB2 OS/390 & Z/

  • Reported component ID

    5740XYR00

  • Reported release

    A10

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2014-06-11

  • Closed date

    2014-08-17

  • Last modified date

    2015-02-12

  • 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.

[{"Line of Business":{"code":"LOB10","label":"Data and AI"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSEPEK","label":"Db2 for z\/OS"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"10.1"}]

Document Information

Modified date:
04 March 2021