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

Obtain the fix for this APAR.

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