IBM Support

IT06627: INCORRECT XML TEMP SUBTREE SIZE CALCULATION LEADING TO VARIOUS XML PROCESSING ERRORS

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • Processing a large XML document that may require XML
    serialization can incorrectly lead to a variety of possible
    errors.
    This can happen if the XML document needs to be serialized
    internally by the DB2 server and it is stored in a temp table.
    Under specific circumstances, it may happen that a few bytes of
    a subtree in the xml document are incorrectly written out to the
    temp which can then lead to unexpected problems and errors when
    the document is reassembled from the temp storage.
    
    For example the errors may be :
    
    SQL0901N  The SQL statement failed because of a non-severe
    system error.
    Subsequent SQL statements can be processed.  (Reason "Unknown
    Node Kind.".)
    SQLSTATE=58004
    
    During SQL processing it returned:
    SQL16129N  XML document expected end of tag "VARIANTS".
    SQLSTATE=2200M
    

Local fix

  • There is no known workaround for this.
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * ALL                                                          *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to DB2 Version 10.1 and Fix Pack 5                   *
    ****************************************************************
    

Problem conclusion

  • Problem was first fixed in DB2 Version 10.1 and Fix Pack 5
    

Temporary fix

Comments

APAR Information

  • APAR number

    IT06627

  • Reported component name

    DB2 FOR LUW

  • Reported component ID

    DB2FORLUW

  • Reported release

    A10

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2015-01-20

  • Closed date

    2015-07-13

  • Last modified date

    2015-07-13

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

    IT02691

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

Fix information

  • Fixed component name

    DB2 FOR LUW

  • Fixed component ID

    DB2FORLUW

Applicable component levels

  • RA10 PSN

       UP

[{"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSEPGG","label":"DB2 for Linux, UNIX and Windows"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"10.1","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
13 July 2015