IBM Support

IC90042: CASTING XML ATOMIC INTO ONE OF SQL CHARACTER TYPES MAY LEAD TO ADM0503C.

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as fixed if next.

Error description

  • In rare scenario casting XML atomic type into one of SQL
    character types may lead to severe exception, in the worst case
    scenario an instance can be brought down. FODC could be
    generated. This type of casting is used for example by XMLTABLE
    function.
    
    If stack is available,
    the sqlriXMLCastXsStringToSQLShortString function is present one
    of the first at the top of it.
    
    e.g.
    
    <StackTrace>
    -----FUNC-ADDR---- ------FUNCTION + OFFSET------
    
    0x000003FFF8AE8316 ossDumpStackTrace + 0x0102
      (/home/db2pcf01/sqllib/lib64/libdb2osse.so.1)
    
    0x000003FFF8AE354E _ZN11OSSTrapFile4dumpEmiP7siginfoPv + 0x00d2
      (/home/db2pcf01/sqllib/lib64/libdb2osse.so.1)
    
    0x000003FFFB6957D2 sqlo_trce + 0x0702
      (/home/db2pcf01/sqllib/lib64/libdb2e.so.1)
    
    0x000003FFFB7300B6 sqloEDUCodeTrapHandler + 0x016a
      (/home/db2pcf01/sqllib/lib64/libdb2e.so.1)
    
    0x000003FFEC409DF0 address: 0x3ffec409df0
    
    0x000003FFFBEA3002_Z36sqlriXMLCastXsStringToSQLShortStringP8sqlr
    r_cbP10
      (/home/db2pcf01/sqllib/lib64/libdb2e.so.1)
    
    0x000003FFFBEA3738 _Z13sqlriXmlToSqlP8sqlrr_cb + 0x05d0
    

Local fix

  • There is no known workaround.
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * All.                                                         *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * Pleas see Error Description.                                 *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to DB2 V9.7 Fix Pack 9 or later.                     *
    ****************************************************************
    

Problem conclusion

Temporary fix

Comments

APAR Information

  • APAR number

    IC90042

  • Reported component name

    DB2 FOR LUW

  • Reported component ID

    DB2FORLUW

  • Reported release

    970

  • Status

    CLOSED FIN

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2013-02-05

  • Closed date

    2013-08-19

  • Last modified date

    2013-08-19

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

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

    IC91822

Fix information

Applicable component levels

  • R950 PSN

       UP

  • R970 PSN

       UP

  • R980 PSN

       UP

  • RA10 PSN

       UP



Document information

More support for: DB2 for Linux, UNIX and Windows

Software version: 9.7

Reference #: IC90042

Modified date: 19 August 2013