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 IC76717 Status: Geschlossen

SELECT ON XML COLUMN CAN CRASH DATABASE.

Produkt:
DB2 FOR LUW / DB2FORLUW / 950 - DB2
Problembeschreibung:
Select on xml column may cause database to crash. 
 
The stack will look like as below: 
 
0x0000002A97EDC7A6 _ZNK17sqlnq_fcscstchild2ppEv + 0x0010 
 
(/view/db2_v95fp7_linuxamd64_n101129/vbs/INST/lib/libdb2e.so.1) 
0x0000002A97F42723 _Z19sqlno_log_bad_statsP9sqlnq_cstii + 0x0025 
 
(/view/db2_v95fp7_linuxamd64_n101129/vbs/INST/lib/libdb2e.so.1) 
0x0000002A97F2C849_Z18sqlno_ff_frq_rangeP13sqlno_globalsP19sqlno 
_ff_essentialsPdjS3_jP10sqlz_valueS5_P9sqlnq_cst14sqlnq_funclass 
S8_f17sqlno_prefix_typePK14sqlrxCollationPfSD_P26sqlno_xml_rngse 
l_interface 
+ 0x0351 
 
(/view/db2_v95fp7_linuxamd64_n101129/vbs/INST/lib/libdb2e.so.1) 
0x0000002A97F18253_Z14sqlno_ff_rangeP13sqlno_globalsP9sqlnq_qncf 
PdS3_S3_jP9sqlnq_cstff14sqlnq_funclassfP10sqlz_valuePfP26sqlno_x 
ml_rngsel_interface 
+ 0x0aef 
 
(/view/db2_v95fp7_linuxamd64_n101129/vbs/INST/lib/libdb2e.so.1) 
0x0000002A981A1E6E_ZN26sqlno_xml_rngsel_interface6rngSelEP13sqln 
o_globalsPfP9sqlnq_pidN10XmlrnStats14XMLRN_ESTIMATEE 
+ 0x037e 
 
(/view/db2_v95fp7_linuxamd64_n101129/vbs/INST/lib/libdb2e.so.1) 
0x0000002A98198712_Z30sqlno_xmlfo_estimateLPatValCntP13sqlno_glo 
balsP9sqlnq_pidP9sqlnq_qncS2_17SQLNO_XMLPRD_TYPEP26sqlno_xml_rng 
sel_interfaceN10XmlrnStats14XMLRN_ESTIMATEEPfSA_ 
+ 0x0a42 
 
(/view/db2_v95fp7_linuxamd64_n101129/vbs/INST/lib/libdb2e.so.1)
Problem-Zusammenfassung:
**************************************************************** 
* USERS AFFECTED:                                              * 
* All users                                                    * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Users need to upgrade to V95 fp9                             * 
****************************************************************
Local-Fix:
n/a
verfügbare FixPacks:
DB2 Version 9.5 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 10 for Linux, UNIX, and Windows

Lösung
Users need to upgrade to V95 fp9
Workaround
keiner bekannt / siehe Local-Fix
Bug-Verfolgung
Vorgänger  : APAR is sysrouted TO one or more of the following: IC78487 
Nachfolger : 
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
31.05.2011
23.04.2012
23.04.2012
Problem behoben ab folgender Versionen (IBM BugInfos)
9.5.FP9
Problem behoben lt. FixList in der Version
9.5.0.9 FixList