home clear 64x64
en blue 200x116 de orange 200x116 info letter User
suche 36x36
Neueste VersionenFixList
11.1.0.7 FixList
10.5.0.9 FixList
10.1.0.6 FixList
9.8.0.5 FixList
9.7.0.11 FixList
9.5.0.10 FixList
9.1.0.12 FixList
Haben Sie Probleme? - Kontaktieren Sie uns.
Kostenlos registrieren anmeldung-x26
Kontaktformular kontakt-x26

DB2 - Problembeschreibung

Problem IC81152 Status: Geschlossen

DB2 ABEND WITH SIG11 FOR A SELECT WITH XML QUERIES

Produkt:
DB2 FOR LUW / DB2FORLUW / 970 - DB2
Problembeschreibung:
DB2 Abnormal Termination with Sig#11 may result from Xml queries 
with similar program error stack. 
 
The trap happens during XML Aggregation exit. 
 
select xmlelement(name "table", xmlattributes('xxx' as "name"), 
xmlconcat(xmlelement(name "types", xmlattributes('INT' as 
"ACCOUNT_ID", 'VARCHAR' as "SOR_IND",'VARCHAR' as "NICKNAME")), 
xmlagg(xmlrow(A.ACCOUNT_ID, TRIM(A.SOR_IND) AS SOR_IND, a.cust 
as cust, '' as "NICKNAME")))), xmlelement(name "table", 
xmlattributes('xxx' as "name"), mlconcat(xmlelement(name 
"types", xmlattributes('INT' as "ACCOUNT_ID", 'VARCHAR' as 
"SOR_IND", 'VARCHAR' as "NICKNAME")), 
xmlagg(xmlrow(A.ACCOUNT_ID, TRIM(A.SOR_IND) AS SOR_IND, a.cust 
as cust, '' as "NICKNAME")))), xmlelement(name "table", 
xmlattributes('xxx' as "name"), xmlconcat(xmlelement(name 
"types", xmlattributes('INT' as "ACCOUNT_ID", 'VARCHAR' as 
SOR_IND", 'VARCHAR' as "NICKNAME")), xmlagg(xmlrow(A.ACCOUNT_ID, 
TRIM(A.SOR_IND) AS SOR_IND, a.cust as cust, '' as 
"NICKNAME")))), xmlelement(name "table", xmlattributes('xxx' as 
"name"), xmlconcat(xmlelement(name "types", xmlattributes('INT' 
as "ACCOUNT_ID", 'VARCHAR' as "SOR_IND", 'VARCHAR' as 
"NICKNAME")), xmlagg(xmlrow(A.ACCOUNT_ID, TRIM(A.SOR_IND) AS 
SOR_IND, a.cust as cust, '' as "NICKNAME")))), xmlelement(name 
"table", xmlattributes('xxx' as "name"), 
xmlconcat(xmlelement(name "types", xmlat 
tributes('INT' as "ACCOUNT_ID", 'VARCHAR' as "SOR_IND", 
'VARCHAR' as "NICKNAME")), xmlagg(xmlrow(A.ACCOUNT_ID, 
TRIM(A.SOR_IND) AS SOR_IND, a.cust as cust, '' as "NICKNAME")))) 
from ty A 
 
-------Frame------ ------Function + Offset------ 
0x09000000068932C4 sqloCrashOnCriticalMemoryValidationFailure + 
0x34 
0x090000000689BCB0 
sqloCrashOnCriticalMemoryValidationFailure@glue6E8 + 0x78 
0x0900000009BB7B44 sqlofmblkEx + 0x4C 
0x09000000081EF008 
writeReferenceNode__19XmlrnSequenceWriterFUcR8XMLS_XIDT1UlT4T 
1PUcT1 + 0x1E0 
0x0900000006102FB4 
addItemSubtree__13XmlrnSequenceFP17xmlDataDescriptor + 0xB4C 
0x09000000066E2108 sqlriXAgg__FP8sqlrr_cb + 0x79C 
0x0900000009D1F504 sqlriagg__FP8sqlrr_cb + 0x1B8 
0x0900000009D2DB84 sqlriSectInvoke__FP8sqlrr_cbP12sqlri_opparm + 
0x28 
0x0900000009E83844 
sqlrr_process_fetch_request__FP14db2UCinterface + 0x184 
0x0900000009CE2F10 
sqlrr_fetch__FP14db2UCinterfaceP15db2UCCursorInfo + 0x518 
0x0900000009CE292C 
sqljs_ddm_cntqry__FP14db2UCinterfaceP13sqljDDMObject + 0xAE4 
0x0900000009CEE308 
sqljsParseRdbAccessed__FP13sqljsDrdaAsCbP13sqljDDMObjectP14db 
2UCinterface + 0x148 
0x0900000009CEE71C 
.sqljsParse.fdpr.clone.77__FP13sqljsDrdaAsCbP14db2UCinterface 
P8sqeAgentb + 0x240
Problem-Zusammenfassung:
**************************************************************** 
* USERS AFFECTED:                                              * 
* DB2 LUW ALL                                                  * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* DB2 encountered Signal#11 from SELECT of XML Query doing xml * 
* aggregation                                                  * 
* because we attempt to free same memory twice during error    * 
* exit condition.                                              * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 v9.7.0.6 ore newer.                           * 
****************************************************************
Local-Fix:
verfügbare FixPacks:
DB2 Version 9.7 Fix Pack 6 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 7 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 8 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows

Lösung
Fixed in DB2 v9.7.0.6 and future releases.
Workaround
keiner bekannt / siehe Local-Fix
Bug-Verfolgung
Vorgänger  : APAR is sysrouted TO one or more of the following: IC84321 
Nachfolger : 
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
01.02.2012
05.06.2012
05.06.2012
Problem behoben ab folgender Versionen (IBM BugInfos)
9.7.0.6
Problem behoben lt. FixList in der Version
9.7.0.6 FixList