IBM Support

IC91822: 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:                                              *
    * XML casting users                                            *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * Plese See Error Description.                                 *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Plese See Error Description.                                 *
    ****************************************************************
    

Problem conclusion

Temporary fix

Comments

APAR Information

  • APAR number

    IC91822

  • Reported component name

    DB2 FOR LUW

  • Reported component ID

    DB2FORLUW

  • Reported release

    A10

  • Status

    CLOSED FIN

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2013-04-23

  • Closed date

    2013-10-02

  • Last modified date

    2013-10-02

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

    IC90042

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

Fix information

Applicable component levels

  • R970 PSN

       UP

  • R980 PSN

       UP

  • RA10 PSN

       UP

  • RA50 PSN

       UP

[{"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSEPGG","label":"DB2 for Linux, UNIX and Windows"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"10.1","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
02 October 2013