IBM Support

PM48926: ABEND0C4 RC00000011 DSNB1GIO +08D2 DUE TO INVALID BUFFER I/O POINTER

A fix is available

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • ABEND0C4 RC00000011 DSNB1GIO +08D2 due to invalid buffer I/O
    pointer caused by error in parallelism clean up during implicit
    cursor close.
    ADDITIONAL SYMPTOMS : SQLCODE433 ABEND0C4 DSNXPDST 1B6A
    ABND=04E-00E50098,M=C8 ,C=101.ASMC-DSNVEUS1,M=DSNVEUS1,
    LOC=DSNVGEPL.DSNVEUS1+1ECC
    ADDITIONAL KEYWORDS : 0C4 RC11 OFFSET08D2 SQLPARALLELISM
    DB2PARALL/K
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED: All Users of CPU and Sysplex Query           *
    *                 Parallelism                                  *
    ****************************************************************
    * PROBLEM DESCRIPTION: ABEND0C4 RC00000010 or RC0000003B from  *
    *                      DSNXPMGR . DSNXPDST +1DAA or            *
    *                      DSNBBM   . DSNB1GIO +083A or            *
    *                      DSNXGRDS . DSNXECLN +0924               *
    *                      when executing an SQL statement that    *
    *                      participates in CPU or Sysplex Query    *
    *                      Parallelism                             *
    ****************************************************************
    * RECOMMENDATION:                                              *
    ****************************************************************
    SQL statements that participate in CPU or Sysplex Query
    Parallelism get additional resources allocated to them in
    order to execute in parallel and these extra resources need
    to be cleaned up when the query is finished running.
                                                                  .
    An error in DB2 code caused some of these resources to be
    either cleaned up too aggressively or not aggressively enough.
    The result is that these resources were either cleaned up
    too soon or too late, respectively. This inconsistent state
    leads to the subject abends in the parallelism resource
    clean up paths or at a later point in the workload.
                                                                  .
    The error is most frequently exposed when the parallel-bound
    statement runs inside of a stored procedure. However, it
    may be exposed without stored procedures.
    

Problem conclusion

  • DB2 code has been changed to clean up CPU or Sysplex Query
    Parallelism resources appropriately.
                                                                  .
                                                                  .
    ADDITIONAL KEYWORDS:
    sqlcpup sysplex sqlsysplexp sqlparallelism DB2PARALL/K
    sqlsp sqlstoredproc
    

Temporary fix

  • *********
    * HIPER *
    *********
    

Comments

APAR Information

  • APAR number

    PM48926

  • Reported component name

    DB2 OS/390 & Z/

  • Reported component ID

    5740XYR00

  • Reported release

    810

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    YesHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2011-09-28

  • Closed date

    2012-02-23

  • Last modified date

    2012-06-20

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

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

    UK76499 UK76500 UK76501

Modules/Macros

  • DSNXECG
    DSNXECL
    DSNXECLF
    DSNXECLN
    

Fix information

  • Fixed component name

    DB2 OS/390 & Z/

  • Fixed component ID

    5740XYR00

Applicable component levels

  • RA10 PSY UK76499

       UP12/03/11 P F203 ½

  • R810 PSY UK76500

       UP12/03/11 P F203 ½

  • R910 PSY UK76501

       UP12/03/11 P F203 ½

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.

[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSEPEK","label":"Db2 for z\/OS"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"8.1","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}},{"Business Unit":{"code":"BU054","label":"Systems w\/TPS"},"Product":{"code":"SG19M","label":"APARs - z\/OS environment"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"8.1","Edition":"","Line of Business":{"code":"","label":""}}]

Document Information

Modified date:
20 June 2012