PM49543: XML STORAGE ENHANCEMENT

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• XML Storage Enhancement
  

Local fix

• N/A
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: All DB2 9 and 10 for z/OS users of pureXML.  *
  ****************************************************************
  * PROBLEM DESCRIPTION: Performance degradation and virtual     *
  *                      storage shortage when processing        *
  *                      a large number of XML documents         *
  *                                                              *
  *                      SQLCODE904 was issued with RC00D50001   *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  This APAR fixes the non-linear performance degradation and
  poor virtual storage usage as the number of XML documents
  processed grows.
  
  For example, in the following query with XMLAGG:
  
  SELECT XMLAGG( XMLQUERY('//Id' PASSING
  XMLELEMENT(NAME "A", XMLCOL ))) FROM T1;
  
  In the above example, when the XMLAGG function is used in a SQL
  statement that aggregates many XML documents in memory, the
  time for running the query and the XML virtual storage usage
  both grow non-linearly.
  

Problem conclusion

• DB2 is updated to improve XML performance and virtual storage
  usage.
  
  Additional Keywords: SQLXML SQLSTORAGE SQLCODE904
  

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:

  UK76153 UK76154

Modules/Macros

• DSNNOBSC DSNNOCCN DSNNOGET DSNNOINS DSNNORES
  DSNNORSQ DSNNOSCO DSNNOXMV DSNNOXVC DSNNQFLR DSNNQIV  DSNNQMD
  DSNNQOB  DSNNQOP  DSNNQOPM DSNNQXCA DSNXDMPS DSNXMLSM
  

Fix information

• Fixed component name

  DB2 OS/390 & Z/

• Fixed component ID

  5740XYR00

Applicable component levels

• RA10 PSY UK76153

     UP12/02/29 P F202

• R910 PSY UK76154

     UP12/02/29 P F202

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.