|
Problem IC67095
|
Status: Closed |
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 |
| product: |
DB2 FOR LUW / DB2FORLUW / 950 - DB2 |
| Problem description: |
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 Summary: |
****************************************************************
* 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 Version 9.5 Fixpack 6 *
**************************************************************** |
| Local Fix: |
Use a smaller size table space like 16k, 8k, etc. |
| available fix packs: |
DB2 Version 9.5 Fix Pack 6a for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 7 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 8 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 10 for Linux, UNIX, and Windows
|
| Solution |
Problem was first fixed in Version 9.5 Fixpack 6 |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 10.03.2010
14.06.2010
14.06.2010 |
| Problem solved at the following versions (IBM BugInfos) |
9.5.FP6
|
| Problem solved according to the fixlist(s) of the following version(s) |
