Latest versionsfixlist
11.1.0.6 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
Have problems? - contact us.
Register for free anmeldung-x26
Contact form kontakt-x26
Question in the chat LiveZilla Live Help

DB2 - Problem description

Problem IC76717 Status: Closed

SELECT ON XML COLUMN CAN CRASH DATABASE.

product:
DB2 FOR LUW / DB2FORLUW / 950 - DB2
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_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 Summary:
**************************************************************** 
* USERS AFFECTED:                                              * 
* All users                                                    * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Users need to upgrade to V95 fp9                             * 
****************************************************************
Local Fix:
n/a
available fix packs:
DB2 Version 9.5 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 10 for Linux, UNIX, and Windows

Solution
Users need to upgrade to V95 fp9
Workaround
not known / see Local fix
BUG-Tracking
forerunner  : APAR is sysrouted TO one or more of the following: IC78487 
follow-up : 
Timestamps
Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :
31.05.2011
23.04.2012
23.04.2012
Problem solved at the following versions (IBM BugInfos)
9.5.FP9
Problem solved according to the fixlist(s) of the following version(s)
9.5.0.9 FixList
This site uses cookies to make it easier for us to provide you with our services. By using our site you agree to the use of cookies.