IBM Support

IC90874: SQL FUNCTION CONTAINING XML ARGUMENTS MIGHT CAUSE DB ABEND

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • Under rare scenarios, DB2 might abend if the following
    conditions are met:
    1. The query contains one or more XML columns
    2. There is at least one predicate of the form:
        SQL function (arguments) <relop> <constant>.
        <relop> refers to any relational operator like equality,
    less than, greater than, etc.
        <constant> refers to any constant value, host variable or
    special register like current_timestamp, etc.
    3. The xml column(s) from 1 is passed in as an argument to the
    SQL function in 2.
    
    DB2 may abend with the following stack:
    
    <StackTrace>
    0x090000000D47C064
    @44@sqlri_position_posstr_locate_short_core__FP8sqlrr_cb11sqlvFu
    ncNumP10sqlz_valueN63 + 0x89C
    0x090000000D47B60C
    sqlri_opparm_position_locate_short__FP8sqlrr_cb + 0x3C0
    0x0900000010CDFAC0
    evalPredicate__14xmlnvXpathNodeFP14XmlnvAutomatonP8sqlrr_cbRbb +
    0xB8
    0x0900000010CF2C34
    m_checkConditions__14XmlnvAutomatonFP19XmlnvWorkArrayEntryiUiT3P
    bRbT6 + 0x440
    0x0900000010CF212C m_closeMatchedEntry__14XmlnvAutomatonFiRiPb +
    0x1D0
    0x0900000010CF0E38 endNode__14XmlnvAutomatonFPb + 0x274
    0x0900000010CE2DAC m_traverse__14XmlnvNavigatorFb + 0x860
    0x0900000010CE2348 getTuple__14XmlnvNavigatorFRbP8sqlrr_cb +
    0x170
    0x090000000E9996AC sqlriXMLScan__FP8sqlrr_cb + 0x214
    0x090000000DB88548 sqlriNljnPiped__FP8sqlrr_cb + 0x4A0
    0x090000000DB898E4 sqlriSectInvoke__FP8sqlrr_cbP12sqlri_opparm +
    0x24
    0x090000000CD63CA8 sqlrr_dss_router__FP8sqlrr_cb + 0x6F0
    0x090000000E5D2600
    sqlrr_subagent_router__FP8sqeAgentP12SQLE_DB2RA_T + 0x5D0
    0x090000000DFBFA58 sqleSubRequestRouter__FP8sqeAgentPUiT2 +
    0x5F0
    0x090000000C985280 sqleProcessSubRequest__FP8sqeAgent + 0x2C84
    0x090000000CB03840 RunEDU__8sqeAgentFv + 0x2EC
    0x090000000D9F8C8C EDUDriver__9sqzEDUObjFv + 0xD8
    0x090000000DA1CB9C sqloEDUEntry + 0x260
    </StackTrace>
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * Using XML columns.                                           *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to DB2 V9.7 Fixpack 9 .                              *
    ****************************************************************
    

Problem conclusion

  • APAR first fixed in DB2 V9.7 Fixpack 9
    

Temporary fix

Comments

APAR Information

  • APAR number

    IC90874

  • 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

    2013-03-14

  • Closed date

    2014-01-13

  • Last modified date

    2014-01-13

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

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

    IC96352 IC96681

Fix information

  • Fixed component name

    DB2 FOR LUW

  • Fixed component ID

    DB2FORLUW

Applicable component levels

  • R970 PSN

       UP



Document information

More support for: DB2 for Linux, UNIX and Windows

Software version: 9.7

Reference #: IC90874

Modified date: 13 January 2014