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

SELECT ON XML COLUMN CAN CRASH DATABASE.

Produkt:
DB2 FOR LUW / DB2FORLUW / 970 - 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                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* 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_globalsP19s * 
* qlno                                                         * 
* _ff_essentialsPdjS3_jP10sqlz_valueS5_P9sqlnq_cst14sqlnq_func * 
* lass                                                         * 
* S8_f17sqlno_prefix_typePK14sqlrxCollationPfSD_P26sqlno_xml_r * 
* ngse                                                         * 
* 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_valuePfP26sql * 
* no_x                                                         * 
* ml_rngsel_interface                                          * 
* + 0x0aef                                                     * 
*                                                              * 
* (/view/db2_v95fp7_linuxamd64_n101129/vbs/INST/lib/libdb2e.so * 
* .1)                                                          * 
* 0x0000002A981A1E6E_ZN26sqlno_xml_rngsel_interface6rngSelEP13 * 
* sqln                                                         * 
* 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)                                                          * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 V9.7 FP5.                                     * 
****************************************************************
Local-Fix:
n/a
verfügbare FixPacks:
DB2 Version 9.7 Fix Pack 5 for Linux, UNIX, and Windows
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
First fixed in DB2 V9.7 FP 5.
Workaround
keiner bekannt / siehe Local-Fix
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
02.09.2011
28.03.2012
28.03.2012
Problem behoben ab folgender Versionen (IBM BugInfos)
9.7.FP5
Problem behoben lt. FixList in der Version
9.7.0.5 FixList