PM82724: ABEND04E RC00E70005 DSNXRSPL M400 AND MSGDSNX908I FROM DSNXEASU SQLCODE905

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• ABEND04E RC00E70005 DSNXRSPL M400
  and MSGDSNX908I from DSNXEASU when a native SQL procedure
  exceeds the ASUTIME LIMIT .  Additional symptom: SQLCODE905
  

Local fix

• Increase the ASUTIME limit for the native SQL procedure.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: All DB2 9 and DB2 10 for z/OS users of       *
  *                 native SQL stored procedures in DEBUG mode.  *
  ****************************************************************
  * PROBLEM DESCRIPTION: An ABEND04E RC00E70005 can occur at     *
  *                      DSNXRSPL M400 when executing a native   *
  *                      SQL stored procedure in DEBUG mode that *
  *                      contains an IF statement when the       *
  *                      ASUTIME limit is exceeded.              *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  An ABEND04E RC00E70005 can occur at location DSNXRSPL M400 when
  executing a native SQL stored procedure in DEBUG mode that
  contains an IF statement when the ASUTIME limit is exceeded.
  
  When ASUTIME has been specified in a native SQL procedure, and
  when it expires during execution, DB2 is expected to issue an
  SQLCODE -905.  Instead, DB2 abends.
  
  Here is a simple example of such a failing native SQL procedure.
  
    CREATE PROCEDURE PROCEDURE1 (var1 INTEGER)
      VERSION V1
      ISOLATION LEVEL CS
      LANGUAGE SQL
      ASUTIME LIMIT 10000
      ALLOW DEBUG MODE
      WLM ENVIRONMENT FOR DEBUG MODE WLMENV1
    P1: BEGIN
      INSERT INTO T1 VALUES(var1);
      IF (var1 > 1) THEN
        SET var1 = var1 - 1;
      END IF;
      RETURN var1;
      END P1
  
  When this procedure is invoked in DEBUG mode, and if ASUTIME has
  expired, DB2 does not handle formatting the SQLCA correctly.
  Hence the abend.
  

Problem conclusion

• The code in DB2 has been modified to correct the ASUTIME
  expiration case for native SQL procedures that contain IF
  statements so the abend will no longer occur.
  
  Additional Keywords: SQLPROCEDURE  SQLCODE905  SQLSP
                       SQLNATIVESQLPL  SQLSTOREDPROC
  

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:

  UK94670 UK94671

Modules/Macros

• DSNXRPL9 DSNXRSPL
  

Fix information

• Fixed component name

  DB2 OS/390 & Z/

• Fixed component ID

  5740XYR00

Applicable component levels

• RA10 PSY UK94670

     UP13/06/18 P F306

• R910 PSY UK94671

     UP13/06/18 P F306

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.