IBM Support

IC78487: SELECT ON XML COLUMN CAN CRASH DATABASE.

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

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

Local fix

  • n/a
    

Problem summary

  • ****************************************************************
    * 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.                                     *
    ****************************************************************
    

Problem conclusion

  • First fixed in DB2 V9.7 FP 5.
    

Temporary fix

Comments

APAR Information

  • APAR number

    IC78487

  • Reported component name

    DB2 FOR LUW

  • Reported component ID

    DB2FORLUW

  • Reported release

    970

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2011-09-02

  • Closed date

    2012-03-28

  • Last modified date

    2012-03-28

  • APAR is sysrouted FROM one or more of the following:

    IC76717

  • APAR is sysrouted TO one or more of the following:

Fix information

  • Fixed component name

    DB2 FOR LUW

  • Fixed component ID

    DB2FORLUW

Applicable component levels

  • R970 PSY

       UP



Document information

More support for: DB2 for Linux, UNIX and Windows

Software version: 9.7

Reference #: IC78487

Modified date: 28 March 2012