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 | |
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 |