IBM Support

IT32856: DB2 MAY TRAP WHEN QUERYING XML COLUMNS WITH THE XMLCAST FUNCTION

Subscribe to this APAR

By subscribing, you receive periodic emails alerting you to the status of the APAR, along with a link to the fix after it becomes available. You can track this item individually or track all items by product.

Notify me when this APAR changes.

Notify me when an APAR for this component changes.

 

APAR status

  • Closed as program error.

Error description

  • DB2 may trap when using the XMLCAST function in a query on a
    table with inlined XML documents. The issue specifically happens
    when documents are small and simple. The stack will be similar
    to the following:
    
    <StackTrace>
    -----Frame------ ------Address----- ------Function +
    Offset------
    0x0000100C113EC190 0x0000100010486DC8
    _ZN17xmlDataDescriptor20packLocalAtomicValueEP11XMLSTORE_CBPS_b
    + 0x0318
      ( = offset 0x10126DC8 in
    /head/home/db2inst1/sqllib/lib64/libdb2e.so.1)
    0x0000100C113EC520 0x000010001047D920
    _ZN17xmlDataDescriptor15packAtomicValueEP11XMLSTORE_CBPS_b +
    0x02f0
      ( = offset 0x1011D920 in
    /head/home/db2inst1/sqllib/lib64/libdb2e.so.1)
    0x0000100C113EC6B0 0x00001000104CB208
    _ZN23XmlrnDocTunnelSeqCursor5fetchEP10sqlz_valuePtthPFiP19sqlri_
    PredFuncParamPiES4_ + 0x0908
      ( = offset 0x1016B208 in
    /head/home/db2inst1/sqllib/lib64/libdb2e.so.1)
    0x0000100C113ECAF0 0x000010000F187C98
    _Z19sqlriXMLCastAtomizeP8sqlrr_cbP17xmlDataDescriptorP10sqlz_val
    ueRb + 0x0138
      ( = offset 0xEE27C98 in
    /head/home/db2inst1/sqllib/lib64/libdb2e.so.1)
    0x0000100C113ECC70 0x000010000F18AAE4
    _Z18sqlriXmlToSql_mainP8sqlrr_cbP10sqlz_valueS2_b + 0x0204
      ( = offset 0xEE2AAE4 in
    /head/home/db2inst1/sqllib/lib64/libdb2e.so.1)
    0x0000100C113ED0C0 0x000010000F18A748
    _Z13sqlriXmlToSqlP8sqlrr_cb + 0x0068
      ( = offset 0xEE2A748 in
    /head/home/db2inst1/sqllib/lib64/libdb2e.so.1)
    0x0000100C113ED110 0x000010000F0FEE90
    _Z17sqlriNljnNonPipedP8sqlrr_cb + 0x0b80
      ( = offset 0xED9EE90 in
    /head/home/db2inst1/sqllib/lib64/libdb2e.so.1)
    0x0000100C113ED4D0 0x000010000F053DE0
    _Z15sqlriSectInvokeP8sqlrr_cbP12sqlri_opparm + 0x0410
      ( = offset 0xECF3DE0 in
    /head/home/db2inst1/sqllib/lib64/libdb2e.so.1)
    0x0000100C113ED620 0x000010000E8EB4B8
    _Z16sqlrr_dss_routerP8sqlrr_cb + 0x0a28
      ( = offset 0xE58B4B8 in
    /head/home/db2inst1/sqllib/lib64/libdb2e.so.1)
    0x0000100C113ED870 0x000010000E8EA0F8
    _Z21sqlrr_subagent_routerP8sqeAgentP12SQLE_DB2RA_T + 0x0ed8
      ( = offset 0xE58A0F8 in
    /head/home/db2inst1/sqllib/lib64/libdb2e.so.1)
    0x0000100C113EDB80 0x000010000B3F4D60
      ( = offset 0xB094D60 in
    /head/home/db2inst1/sqllib/lib64/libdb2e.so.1)
    0x0000100C113EDDE0 0x000010000B3EF434
    _Z21sqleProcessSubRequestP8sqeAgent + 0x2374
      ( = offset 0xB08F434 in
    /head/home/db2inst1/sqllib/lib64/libdb2e.so.1)
    0x0000100C113EE210 0x000010000B46D528 _ZN8sqeAgent6RunEDUEv +
    0x09d8
      ( = offset 0xB10D528 in
    /head/home/db2inst1/sqllib/lib64/libdb2e.so.1)
    0x0000100C113EE3D0 0x000010001032DB04 _ZN9sqzEDUObj9EDUDriverEv
    + 0x0344
      ( = offset 0xFFCDB04 in
    /head/home/db2inst1/sqllib/lib64/libdb2e.so.1)
    0x0000100C113EE440 0x000010001032D79C _Z10sqlzRunEDUPcj + 0x001c
      ( = offset 0xFFCD79C in
    /head/home/db2inst1/sqllib/lib64/libdb2e.so.1)
    0x0000100C113EE460 0x000010000E072DE4 sqloEDUEntry + 0x0334
      ( = offset 0xDD12DE4 in
    /head/home/db2inst1/sqllib/lib64/libdb2e.so.1)
    0x0000100C113EE790 0x0000100000088B94
      ( = offset 0x8B94 in /lib64/libpthread.so.0)
    0x0000100C113EEA10 0x0000100016EB85F4 clone + 0x00e4
      ( = offset 0x1285F4 in /lib64/libc.so.6)
    </StackTrace>
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * all                                                          *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to Db2 11.1.4.6 or higher                            *
    ****************************************************************
    

Problem conclusion

  • Upgrade to Db2 11.1.4.6 or higher
    

Temporary fix

Comments

APAR Information

  • APAR number

    IT32856

  • Reported component name

    DB2 FOR LUW

  • Reported component ID

    DB2FORLUW

  • Reported release

    B10

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2020-05-13

  • Closed date

    2021-03-31

  • Last modified date

    2021-03-31

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

  • 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

[{"Line of Business":{"code":"LOB10","label":"Data and AI"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SSEPGG","label":"Db2 for Linux, UNIX and Windows"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"11.1"}]

Document Information

Modified date:
01 April 2021