DB2 - Problembeschreibung
Problem IC67201 | Status: Geschlossen |
SQL1224N MAY OCCUR WHEN DOING AN INSERT OR UPDATE ON AN XML INLI NE COLUMN AND THE COLUMN IS DEFINED IN A TABLE USING A 32K PAGE | |
Produkt: | |
DB2 FOR LUW / DB2FORLUW / 980 - DB2 | |
Problembeschreibung: | |
The following trap can be triggered when doing an Insert or Update on an XML column which is INLINED and that column is defined in a 32k page table. The error can only occur in these conditions, a 32k page allows for a large enough buffer to hold an in-memory subtree of size > Uint16 before writing it out to disk. When the size of the subtree is calculated to determine whether it fits in the user specified INLINE column length, the size value is too large for the defined Uint16 type variable and is overflowed. The bad size value can then lead to data corruption since the calculated size is no longer valid and we could potentially be writing the document to the base table instead of out to perm. Stack #1 Signal #11 0 ossDumpStackTraceEx 1 OSSTrapFile::dumpEx 2 sqlo_trce 3 sqloEDUCodeTrapHandler 4 __restore_rt 5 sqlofmblkEx 6 sqlofmblk 7 XmlsNidStack::~XmlsNidStack 8 XmlrnXTransformer 9 XmlrnXTransformer::~XmlrnXTransformer 10 xmlrnApplyPUL 11 xmlrnInsertDocument 12 sqldInsertXMLDocument 13 sqldFormatXDADesc 14 sqldFullFormatFixedVar 15 sqldRowUpdate 16 sqlriupd | |
Problem-Zusammenfassung: | |
**************************************************************** * USERS AFFECTED: * * ALL * **************************************************************** * PROBLEM DESCRIPTION: * * SQL1224N MAY OCCUR WHEN DOING AN INSERT OR UPDATE ON AN * * XMLINLINE COLUMN AND THE COLUMN IS DEFINED IN A TABLE USING * * A 32KPAGE * **************************************************************** * RECOMMENDATION: * * Upgrade to DB2 Version 9.8 Fixpack 3 * **************************************************************** | |
Local-Fix: | |
verfügbare FixPacks: | |
DB2 Version 9.8 Fix Pack 3 for Linux, UNIX, and Windows | |
Lösung | |
Problem was first fixed in DB2 Version 9.8 Fixpack 3 | |
Workaround | |
keiner bekannt / siehe Local-Fix | |
Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 12.03.2010 10.01.2011 10.01.2011 |
Problem behoben ab folgender Versionen (IBM BugInfos) | |
9.8.FP3 | |
Problem behoben lt. FixList in der Version | |
9.8.0.3 |