IBM Support

IC81152: DB2 ABEND WITH SIG11 FOR A SELECT WITH XML QUERIES

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • DB2 Abnormal Termination with Sig#11 may result from Xml queries
    with similar program error stack.
    
    The trap happens during XML Aggregation exit.
    
    select xmlelement(name "table", xmlattributes('xxx' as "name"),
    xmlconcat(xmlelement(name "types", xmlattributes('INT' as
    "ACCOUNT_ID", 'VARCHAR' as "SOR_IND",'VARCHAR' as "NICKNAME")),
    xmlagg(xmlrow(A.ACCOUNT_ID, TRIM(A.SOR_IND) AS SOR_IND, a.cust
    as cust, '' as "NICKNAME")))), xmlelement(name "table",
    xmlattributes('xxx' as "name"), mlconcat(xmlelement(name
    "types", xmlattributes('INT' as "ACCOUNT_ID", 'VARCHAR' as
    "SOR_IND", 'VARCHAR' as "NICKNAME")),
    xmlagg(xmlrow(A.ACCOUNT_ID, TRIM(A.SOR_IND) AS SOR_IND, a.cust
    as cust, '' as "NICKNAME")))), xmlelement(name "table",
    xmlattributes('xxx' as "name"), xmlconcat(xmlelement(name
    "types", xmlattributes('INT' as "ACCOUNT_ID", 'VARCHAR' as
    SOR_IND", 'VARCHAR' as "NICKNAME")), xmlagg(xmlrow(A.ACCOUNT_ID,
    TRIM(A.SOR_IND) AS SOR_IND, a.cust as cust, '' as
    "NICKNAME")))), xmlelement(name "table", xmlattributes('xxx' as
    "name"), xmlconcat(xmlelement(name "types", xmlattributes('INT'
    as "ACCOUNT_ID", 'VARCHAR' as "SOR_IND", 'VARCHAR' as
    "NICKNAME")), xmlagg(xmlrow(A.ACCOUNT_ID, TRIM(A.SOR_IND) AS
    SOR_IND, a.cust as cust, '' as "NICKNAME")))), xmlelement(name
    "table", xmlattributes('xxx' as "name"),
    xmlconcat(xmlelement(name "types", xmlat
    tributes('INT' as "ACCOUNT_ID", 'VARCHAR' as "SOR_IND",
    'VARCHAR' as "NICKNAME")), xmlagg(xmlrow(A.ACCOUNT_ID,
    TRIM(A.SOR_IND) AS SOR_IND, a.cust as cust, '' as "NICKNAME"))))
    from ty A
    
    -------Frame------ ------Function + Offset------
    0x09000000068932C4 sqloCrashOnCriticalMemoryValidationFailure +
    0x34
    0x090000000689BCB0
    sqloCrashOnCriticalMemoryValidationFailure@glue6E8 + 0x78
    0x0900000009BB7B44 sqlofmblkEx + 0x4C
    0x09000000081EF008
    writeReferenceNode__19XmlrnSequenceWriterFUcR8XMLS_XIDT1UlT4T
    1PUcT1 + 0x1E0
    0x0900000006102FB4
    addItemSubtree__13XmlrnSequenceFP17xmlDataDescriptor + 0xB4C
    0x09000000066E2108 sqlriXAgg__FP8sqlrr_cb + 0x79C
    0x0900000009D1F504 sqlriagg__FP8sqlrr_cb + 0x1B8
    0x0900000009D2DB84 sqlriSectInvoke__FP8sqlrr_cbP12sqlri_opparm +
    0x28
    0x0900000009E83844
    sqlrr_process_fetch_request__FP14db2UCinterface + 0x184
    0x0900000009CE2F10
    sqlrr_fetch__FP14db2UCinterfaceP15db2UCCursorInfo + 0x518
    0x0900000009CE292C
    sqljs_ddm_cntqry__FP14db2UCinterfaceP13sqljDDMObject + 0xAE4
    0x0900000009CEE308
    sqljsParseRdbAccessed__FP13sqljsDrdaAsCbP13sqljDDMObjectP14db
    2UCinterface + 0x148
    0x0900000009CEE71C
    .sqljsParse.fdpr.clone.77__FP13sqljsDrdaAsCbP14db2UCinterface
    P8sqeAgentb + 0x240
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * DB2 LUW ALL                                                  *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * DB2 encountered Signal#11 from SELECT of XML Query doing xml *
    * aggregation                                                  *
    * because we attempt to free same memory twice during error    *
    * exit condition.                                              *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to DB2 v9.7.0.6 ore newer.                           *
    ****************************************************************
    

Problem conclusion

  • Fixed in DB2 v9.7.0.6 and future releases.
    

Temporary fix

Comments

APAR Information

  • APAR number

    IC81152

  • 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

    2012-02-01

  • Closed date

    2012-06-05

  • Last modified date

    2012-06-05

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

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

    IC84321

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 #: IC81152

Modified date: 05 June 2012