DB2 FOR LUW / DB2FORLUW / A10 - DB2

If ALL of the following conditions are true: 
 
1) On DPF, a query is run that flows an XML column on a TQ 
 
2) A table in the query has it's XML column defined with a 
specific inline length. 
 
For example: 
create table tester(col1 xml inline length 2000) 
 
3) The query is interrupted (for example, force applications, or 
some other event or error that interrupts the query). 
 
...then there is a chance that the cleanup logic for terminating 
the query may reference an empty internal structure, cause the 
trap/crash. 
 
The trap will be sustained by DB2.  The following is the stack 
that corresponds to this problem: 
 
 
-------Frame------ ------Function + Offset------ 
0x09000000050E2D60 
recycleAndReinit__24SqlriXmlDeferredTempListFP30SqlriXmlDeferred 
TempMemoryPool + 0x70 
0x090000000544A5F8 
m_decrDeferCount__27SqlriXmlDeferredTempManagerFP24SqlriXmlDefer 
redTempListP8sqlrr_cbb + 0x1EC 
0x0900000004D7EC48 
unDeferDeleteXTemps__27SqlriXmlDeferredTempManagerFR8XMLS_XIDP8s 
qlrr_cb + 0x194 
0x0900000004D7E924 
doGarbageCollect__29sqlktLargeObjCacheXMLValueMgrFR23sqlktLargeO 
bjCacheValue + 0xA0 
0x0900000004D7E3D8 evictionNotice__23sqlktLargeObjCacheValueFv + 
0xA4 
0x0900000004D81BF8 
evictEntry__30sqlktLargeObjCacheGatewayOnTQAFUl@AF277_219 + 
0x11C 
0x0900000004D7E110 
evictEntry__30sqlktLargeObjCacheGatewayOnTQAFUl + 0x1C 
0x0900000004D4791C 
destroyLargeObjCacheGateway__25sqlktLargeObjCacheGatewayFRP25sql 
ktLargeObjCacheGateway + 0x88 
0x0900000004764654 sqlktdrp__FP8sqeAgentP9sqlri_taoi + 0x704 
0x0900000004766794 sqlktdrp__FP8sqeAgentP9sqlri_taoi@glueBCB + 
0x78 
0x0900000005242E3C sqlridrp__FP8sqlrr_cbP9sqlri_tao + 0x17C 
0x0900000005ACE8E8 sqlridrp__FP8sqlrr_cbP9sqlri_tao@glueBC2 + 
0x80 
0x0900000005ACECC8 sqlricls_complex__FP8sqlrr_cbilN23 + 0x9C 
0x0900000005BDA2C8 sqlricls_complex__FP8sqlrr_cbilN23@glue8B8 + 
0x128 
0x0900000005BDE968 @44@259738@sqlricls__FP8sqlrr_cbiN32 + 0xB0 
0x0900000006C0250C sqlriecc__FP8sqlrr_cbilT3 + 0xEC4 
0x0900000006F85260 sqlriCloseExecuteSectionComplex__FP8sqlrr_cbi 
+ 0x4B8 
0x090000000991CEE4 
.sqlrr_process_execute_request.fdpr.clone.2089__FP8sqlrr_cbi + 
0xB54 
0x0900000005BB3630 
.sqlrr_execute.fdpr.clone.1820__FP14db2UCinterfaceP9UCstpInfo + 
0x208 
0x0900000005BB2FA8 
.sqljs_ddm_excsqlstt.fdpr.clone.201__FP14db2UCinterfaceP13sqljDD 
MObject + 0xB80 
0x0900000005BB1DE8 
sqljsParseRdbAccessed__FP13sqljsDrdaAsCbP13sqljDDMObjectP14db2UC 
interface + 0x104 
0x0900000005BB2184 
.sqljsParse.fdpr.clone.31__FP13sqljsDrdaAsCbP14db2UCinterfaceP8s 
qeAgentb + 0x260 
0x0900000005BB0C04 @63@sqljsSqlam__FP14db2UCinterfaceP8sqeAgentb 
+ 0x2EC 
0x09000000059EE608 
@63@sqljsDriveRequests__FP8sqeAgentP14db2UCconHandle + 0xA4 
0x09000000049C1708 
@63@sqljsDrdaAsInnerDriver__FP18SQLCC_INITSTRUCT_Tb + 0x38C 
0x09000000059EDCE0 sqljsDrdaAsDriver__FP18SQLCC_INITSTRUCT_T + 
0x1D0 
0x0900000005A61504 RunEDU__8sqeAgentFv + 0x2F0 
0x0900000005A5B0CC EDUDriver__9sqzEDUObjFv + 0xD8 
0x0900000005AC3A10 sqloEDUEntry + 0x260

**************************************************************** 
* USERS AFFECTED:                                              * 
* Any doing XML queries in DPF environment                     * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 version 10 fixpack 3 or later                 * 
****************************************************************

DB2 Version 10.1 Fix Pack 3 for Linux, UNIX, and Windows
 DB2 Version 10.1 Fix Pack 4 for Linux, UNIX, and Windows
 DB2 Version 10.1 Fix Pack 3a for Linux, UNIX, and Windows
 DB2 Version 10.1 Fix Pack 6 for Linux, UNIX, and Windows
 

Problem first fixed in DB2 version 10 fixpack 3

keiner bekannt / siehe Local-Fix

Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:

22.04.2013
28.10.2013
28.10.2013