IBM Support

PK56857: SQL STATEMENT LARGER THAN ACTUAL SIZE OF BUFFER CAN NOT GET ENOUGH STORAGE SPACE AND CAUSE ABEND 0C4 RC11 DSNXECP +1262

A fix is available

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • SQL statement passed in to DB2 is larger than the actual size of
    the buffer. Not enough storage is being obtained to contain the
    full length of the SQL statement and causes the ABEND 0C4 RC=11
    DSNXECP +1262.
    

Local fix

  • No Work Around
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED: All users of DSNREXX, the DB2 REXX Language  *
    *                 Support.                                     *
    ****************************************************************
    * PROBLEM DESCRIPTION: When processing a large input SQL       *
    *                      statement, DSNREXX results in one       *
    *                      of the following:                       *
    *                       (1) Abend 0C4 (ABEND0C4)               *
    *                       (2) SQLCODE -104 (SQLCODE104)          *
    ****************************************************************
    * RECOMMENDATION:                                              *
    ****************************************************************
    DSNREXX uses a buffer to process SQL
    statements.
    
    For non-prepared statements and for
    non-execute immediate statements,
    DSNREXX does not increase the buffer.
    
    This results in one of the following:
     (1) Abend 0C4 (ABEND0C4)
     (2) SQLCODE -104 (SQLCODE104)
    

Problem conclusion

  • DSNREXX has been modified to increase the buffer.
    

Temporary fix

Comments

APAR Information

  • APAR number

    PK56857

  • Reported component name

    DB2 OS/390 & Z/

  • Reported component ID

    5740XYR00

  • Reported release

    810

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2007-11-20

  • Closed date

    2008-02-07

  • Last modified date

    2008-03-03

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

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

    UK33574 UK33575

Modules/Macros

  • DSNTZDDL
    

Fix information

  • Fixed component name

    DB2 OS/390 & Z/

  • Fixed component ID

    5740XYR00

Applicable component levels

  • R810 PSY UK33574

       UP08/02/26 P F802

  • R910 PSY UK33575

       UP08/02/26 P F802

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.



Document information

More support for: DB2 for z/OS

Software version: 8.1

Reference #: PK56857

Modified date: 03 March 2008