PM82724: ABEND04E RC00E70005 DSNXRSPL M400 AND MSGDSNX908I FROM DSNXEASU SQLCODE905

A fix is available

Subscribe

You can track all active APARs for this component.

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 number

    PM82724

  • Reported component name

    DB2 OS/390 & Z/

  • Reported component ID

    5740XYR00

  • Reported release

    A10

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2013-02-13

  • Closed date

    2013-05-28

  • Last modified date

    2013-07-03

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



Rate this page:

(0 users)Average rating

Add comments

Document information


More support for:

DB2 for z/OS

Software version:

A10

Reference #:

PM82724

Modified date:

2013-07-03

Translate my page

Machine Translation

Content navigation