PM33771: THE APAR FIXES THE FOLLOWING ISSUES: 04E-00E20009 AND 04E-00E70005

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• The APAR is for the following abends in DB2 V10
  (d143567) 04E-00E20009,   ,LOC=DSNNOBXI.DSNSVSFB+0806
  (d146449) 04e-00e70005,loc=dsnnxml .dsnnobxi:m224
  

Local fix

• No Work Around
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: All DB2 10 for z/OS users of XML.            *
  ****************************************************************
  * PROBLEM DESCRIPTION: DB2 10 for z/OS problems when inserting *
  *                      an XML document using Extensible        *
  *                      Dynamic Binary XML DB2 Client/Server    *
  *                      Binary XML Format(IBM defined binary    *
  *                      XML format):                            *
  *                                                              *
  *                      ABEND04E RC00E20009                     *
  *                      DSNNOBXI.DSNSVSFB+0806                  *
  *                                                              *
  *                      ABEND0C4 RC00000010                     *
  *                      DSNNXML.DSNNOBXI+1298                   *
  *                                                              *
  *                      ABEND04E RC00E70005                     *
  *                      DSNNXML.DSNNOBXI:M224                   *
  *                                                              *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  ABEND0E4 RC00E20009 DSNNOBXI.DSNSVSFB+0806 or
  ABEND0C4 RC00000010 DSNNXML.DSNNOBXI+1298 could occur when
  insert, LOAD, or update into an XML column using binary XML.
  The abends were most likely to occur when inserting an XML
  document that is larger than 128K bytes. The problem happened
  because an invalid storage length was requested.
  
  ABEND0E4 RC00E70005 DSNNXML.DSNNOBXI.M224 occurred when
  there was an undefined string id in a binary XML stream
  during insert, LOAD, or update into an XML column.
  

Problem conclusion

• The above DB2 10 for z/OS problems related with binary XML
  were fixed. For the undefined string id problem, SQLCODE -20465
  will be issued instead of abend.
  
  Additional keywords: SQLXML
  

Temporary fix

Comments

APAR Information

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

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

  UK66762

Modules/Macros

• DSNNOBXI
  

Fix information

• Fixed component name

  DB2 OS/390 & Z/

• Fixed component ID

  5740XYR00

Applicable component levels

• RA10 PSY UK66762

     UP11/04/29 P F104

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.