DB2 - Problem description
Problem IT02691 | Status: Closed |
INCORRECT XML TEMP SUBTREE SIZE CALCULATION LEADING TO VARIOUS XML PROCESSING ERRORS | |
product: | |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 | |
Problem 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 | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * XML data type users. * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade the database server to V9.7 Fix Pack 10 * **************************************************************** | |
Local Fix: | |
There is no known workaround for this. | |
Solution | |
This problem was first fixed in V9.7 Fix Pack 10 | |
Workaround | |
not known / see Local fix | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 20.06.2014 10.11.2014 10.11.2014 |
Problem solved at the following versions (IBM BugInfos) | |
9.7.FP10 | |
Problem solved according to the fixlist(s) of the following version(s) | |
9.7.0.10 |