IBM Support

PM83072: ABEND04E RC00E20005 DSNNXCMT DSNSVSVB +08F2

A fix is available

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • ABEND04E RC00E20005 DSNNXCMT DSNSVSVB +08F2
    .
    Additional symptoms:
    ABEND0C4 RC00000038 DSNNXML DSNNORES +43C0
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED: All DB2 9 and 10 for z/OS users of XML.      *
    ****************************************************************
    * PROBLEM DESCRIPTION: The following may occur when running    *
    *                      multiple SQL/XML statements in the same *
    *                      application:                            *
    *                                                              *
    *                      ABEND04E RC00E20005 in module           *
    *                      DSNNXCMT DSNSVSVB offset +08F2          *
    *                                                              *
    *                      ABEND0C4 RC00000038 in module           *
    *                      DSNNXML DSNNORES offset +43C0           *
    ****************************************************************
    * RECOMMENDATION:                                              *
    ****************************************************************
    When running multiple SQL/XML statements that require in
    memory copy of the documents, DB2 will re-use the working
    buffer. However, when the current document is 2 or more times
    bigger than the previous document, there is a logic error in
    extending the buffer which causes insufficient storage
    allocation.
    
    Below is an example of such SQL/XMl statement:
    
    SELECT XMLQUERY('$doc/a/b/c'
      PASSING XMLPARSE(DOCUMENT CAST(? AS BLOB(20000)))
             AS "doc")
    FROM SYSIBM.SYSDUMMY1;
    
    Within the same application, the above statement is first
    executed with a 4K XML document. Then, when re-executed, the
    same statement has a 12K XML document and an abend may occur.
    

Problem conclusion

  • The above DB2 9 and 10 for z/OS problem was fixed to ensure
    there is sufficient storage for big documents.
    
    Additional keywords: SQLXML DB2OVRLAY/K
    

Temporary fix

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

Comments

APAR Information

  • APAR number

    PM83072

  • Reported component name

    DB2 OS/390 & Z/

  • Reported component ID

    5740XYR00

  • Reported release

    910

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    YesHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2013-02-18

  • Closed date

    2013-04-17

  • Last modified date

    2013-06-04

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

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

    UK93546 UK93547

Modules/Macros

  • DSNNOBXI DSNNOCCN DSNNORCN DSNNORES
    

Fix information

  • Fixed component name

    DB2 OS/390 & Z/

  • Fixed component ID

    5740XYR00

Applicable component levels

  • RA10 PSY UK93546

       UP13/05/03 P F305

  • R910 PSY UK93547

       UP13/05/03 P F305

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":"9.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":"9.1","Edition":"","Line of Business":{"code":"","label":""}}]

Document Information

Modified date:
04 June 2013