IBM Support

PI33337: ABEND04E RC00E2000C ISSUED AT DSNXOYP1 DSNSVSVB +0B06 OFFSET0B06WHEN SETTING A PATH FOR A SQLPL APPLICATION

A fix is available

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • ABEND04E RC00E2000C ISSUED AT DSNXOYP1 DSNSVSVB +0B06 OFFSET0B06
    WHEN SETTING A PATH FOR A SQLPL APPLICATION
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED: All DB2 10 for z/OS users of a native SQL    *
    *                 procedure or compiled SQL scalar function    *
    *                 containing a statement with a SQL variable   *
    *                 which references a user defined data type.   *
    *                 All DB2 11 for z/OS users of a native SQL    *
    *                 procedure or compiled SQL scalar function.   *
    *                                                              *
    ****************************************************************
    * PROBLEM DESCRIPTION: An ABEND04E RC00E2000C at location      *
    *                      DSNXOYP1 DSNSVSVB OFFSET0B06 may occur  *
    *                      when a SQL statement satisfies the      *
    *                      following list of conditions:           *
    *                                                              *
    *                      For DB2 10:                             *
    *                                                              *
    *                      A native SQL procedure or compiled      *
    *                      SQL scalar function contains a          *
    *                      statement with a SQL variable which     *
    *                      references a user defined data type.    *
    *                                                              *
    *                      For DB2 11:                             *
    *                                                              *
    *                      A native SQL procedure or compiled      *
    *                      SQL scalar function may cause           *
    *                      possible memory leak in general.        *
    *                                                              *
    ****************************************************************
    * RECOMMENDATION:                                              *
    ****************************************************************
    The following example helps to illustrate the problem.
    
    Step 1. Create objects.
    
    CREATE TABLE T1(
      C1 VARCHAR(8),
      C2 VARCHAR(2)
    )!
    
    Step 2. Statements which may cause ABEND.
    
    For DB2 10 and 11:
    
    Example#1:
    CREATE TYPE MYINT AS INTEGER!
    
    CREATE PROCEDURE P1()
      BEGIN
        DECLARE VAR1 MYINT;
        SET VAR1 = 5;
    END!
    
    For DB2 11 only:
    
    Example#2:
    CREATE VARIABLE VAR2 VARCHAR(8)!
    CREATE PROCEDURE P1()
      BEGIN
        DECLARE VAR1 VARCHAR(8);
        SET VAR1 = VAR2;
    END!
    
    Example#3:
    CREATE PROCEDURE P1()
      BEGIN
        DECLARE VAR1 VARCHAR(8);
        SET VAR1 = ( SELECT C1 FROM T1
                     FETCH FIRST 1 ROWS ONLY);
    END !
    
    DB2 does not free storage properly when process column C1
    which may result in the ABEND.
    
    The ABEND occurs because DB2 run out of storage since the
    storage that are allocated when processing the statement
    CREATE PROCEDURE isn't freed.
    

Problem conclusion

  • DB2 has been modified correctly to free storage when
    processing a native SQL procedure or compiled SQL scalar
    function.
    
    Additional Keywords: SQLSP SQLSTOREDPROC SQLNATIVESQLPL
                         SQLUDF SQLSTORAGE DB2STGLK/K
    

Temporary fix

  • *********
    * HIPER *
    *********
    

Comments

APAR Information

  • APAR number

    PI33337

  • Reported component name

    DB2 OS/390 & Z/

  • Reported component ID

    5740XYR00

  • Reported release

    B10

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    YesHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2015-01-22

  • Closed date

    2015-03-17

  • Last modified date

    2015-04-02

  • APAR is sysrouted FROM one or more of the following:

  • APAR is sysrouted TO one or more of the following:

    UI25987 UI25988

Modules/Macros

  •    DSNXOYCS DSNXOYDA DSNXOYDB DSNXOYIF DSNXOYPC
    DSNXOYPL DSNXOYP0 DSNXOYP1 DSNXOYTR
    

Fix information

  • Fixed component name

    DB2 OS/390 & Z/

  • Fixed component ID

    5740XYR00

Applicable component levels

  • RA10 PSY UI25987

       UP15/04/01 P F503 Ž

  • RB10 PSY UI25988

       UP15/04/01 P F503 Ž

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.

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

Document Information

Modified date:
06 May 2020