PM88490: ABEND04E RC00E20018 AT DSNSLD4 .DSNSTKGG FOR AN INSERT STATEMENT WITH SYNTAX ERROR

A fix is available

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • ABEND04E RC00E20018 occurred at DSNSLD4 .DSNSTKGG
    from an INSERT statement with syntax error. The
    erroneous SQL statement is as follows:
    INSERT INTO TABLE1 (COL1) VALUES('123456','123456', '123456',
    '123456'........) where there are thousands of literals for
    one single column.  The stack trace shows DSNXOP0 called
    several thousands times and depleted the stack storage.
    SQLCODE-117 should be issued.
    

Local fix

  • use correct INSERT statement syntax.
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED: All DB2 10 for z/OS users of an INSERT SQL   *
    *                 statement that contains more than 750 items  *
    *                 in the VALUES clause.                        *
    ****************************************************************
    * PROBLEM DESCRIPTION: ABEND04E RC00E20018 at the location     *
    *                      DSNSLD4 DSNSTKGG OFFSET 0D3A could      *
    *                      happen instead of SQLCODE -117 for an   *
    *                      INSERT SQL statement that contains more *
    *                      than 750 items in the VALUES clause.    *
    ****************************************************************
    * RECOMMENDATION:                                              *
    ****************************************************************
    An example is shown below:
    
    INSERT INTO T1(ONECOL) VALUES(1, 2, 3, 4, ... 100000);
    
    DB2 did not correctly issue SQLCODE -117 while processing the
    aforementioned INSERT SQL statements, which caused the ABEND.
    

Problem conclusion

  • DB2 has been modified to correctly process the aforementioned
    INSERT SQL statement, and SQLCODE -117 will be issued.
    
    Additional keywords: SQLINSERT SQLCODE117
    

Temporary fix

Comments

APAR Information

  • APAR number

    PM88490

  • 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-05-06

  • Closed date

    2013-06-24

  • Last modified date

    2013-08-02

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

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

    UK95378

Modules/Macros

  •    DSNXOP0
    

Fix information

  • Fixed component name

    DB2 OS/390 & Z/

  • Fixed component ID

    5740XYR00

Applicable component levels

  • RA10 PSY UK95378

       UP13/07/10 P F307

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 #:

PM88490

Modified date:

2013-08-02

Translate my page

Machine Translation

Content navigation