PM02613: XMLSERIALIZE TO SERIALIZE THE XML TO A CLOB GETS A -904

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• XMLSERIALIZE to serialize the XML to a CLOB gets a -904
  

Local fix

• No Work Around
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: All DB2 9 for z/OS users of the XMLSERIALIZE *
  *                 function.                                    *
  ****************************************************************
  * PROBLEM DESCRIPTION: An SQLCODE904 or -904 with a reason     *
  *                      code rc00D50001 can occur for a query   *
  *                      which has many iterations of the        *
  *                      XMLSERIALIZE function.                  *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  An SQLCODE904 or -904 with a reason code of rc00D50001 can occur
  for a query which has many iterations of the XMLSERIALIZE
  functions.  In the reported case, XMLSERIALIZE is used
  to serialize the XML to a CLOB and received the SQLCODE -904
  error after processing some 355 XML columns, each having an
  approximate length of 512 KB.  Currently, DB2 uses XML memory to
  temporarily cache the XMLSERIALIZE output.  However, because DB2
  did not reuse this memory, the -904 is issued.  DB2 should reuse
  the memory after each row.
  
  The following example illustrates a failing case exhibiting many
  iterations of the XMLSERIALIZE function that can result in
  accumulating XML storage if T2 has many rows.
  
  
     SELECT XMLSERIALIZE(XMLDATA AS CLOB(1M)),
            XMLSERIALIZE(XMLDATA AS CLOB(1M))
     FROM T2;
  

Problem conclusion

• DB2 is modified to reuse the XML storage for the XMLSERIALIZE
  function to prevent the SQLCODE904 condition.
  
  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:

  UK57386

Modules/Macros

• DSNXGSFN DSNXOAUX DSNXOOS2
  

Fix information

• Fixed component name

  DB2 OS/390 & Z/

• Fixed component ID

  5740XYR00

Applicable component levels

• R910 PSY UK57386

     UP10/06/16 P F006

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.