IBM Support

IT26954: Db2 server may trap in ICU processing date-time 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 server may trap in ICU processing date-time function.
    
    Stack trace may look like:
    x000003FF7CC4788E udata_openChoice_44_db2 + 0x005e
                    (/home/db2inst1/sqllib/lib64/libicuucdb2.so.44)
    0
    0x000003FF7CC6AEB6 ures_openDirect_44_db2 + 0x008e
                    (/home/db2inst1/sqllib/lib64/libicuucdb2.so.44)
    0x000003FF7D5CBD5C address: 0x000003FF7D5CBD5C ; dladdress:
    0x000003FF7D500000 ; offset in lib: 0x00000000000CBD5C ;
    
    (/home/db2inst1/sqllib/lib64/libicui18ndb2.so.44)
    0x000003FF7D5CC030
    _ZN10icu_44_db28Calendar14createInstanceEPNS_8TimeZoneERKNS_6Loc
    aleER10UErrorCode + 0x0150
    
    (/home/db2inst1/sqllib/lib64/libicui18ndb2.so.44)
    0x000003FF7D58EE24
    _ZN10icu_44_db216SimpleDateFormat18initializeCalendarEPNS_8TimeZ
    oneERKNS_6LocaleER10UErrorCode + 0x0038
    
    (/home/db2inst1/sqllib/lib64/libicui18ndb2.so.44)
    0x000003FF7D5923D2
    _ZN10icu_44_db216SimpleDateFormatC1ERKNS_13UnicodeStringERKNS_6L
    ocaleER10UErrorCode + 0x00c6
    
    (/home/db2inst1/sqllib/lib64/libicui18ndb2.so.44)
    0x000003FF7D5A309E udat_open_44_db2 + 0x01e2
    
    (/home/db2inst1/sqllib/lib64/libicui18ndb2.so.44)
    0x000003FF84E04AA6 sqlnlsICUUdatOpen_CLDR181 + 0x0346
                    (/home/db2inst1/sqllib/lib64/libdb2e.so.1)
    0x000003FF84DD9892
    _Z17sqlnlsICUUdatOpenPKcS0_iS0_ibPPv16sqlnlsUnicodeVer + 0x00b6
                    (/home/db2inst1/sqllib/lib64/libdb2e.so.1)
    0x000003FF84DD8E8A sqlnlsUdatFindORAddNode + 0x0596
                    (/home/db2inst1/sqllib/lib64/libdb2e.so.1)
    0x000003FF84E011D4
    _Z29sqlnlsICUDateToSymbol_CLDR181PKhPh20sqlnlsDateTimeFormatP10s
    qlz_valuePKcPiP15sqlnlsUDATChain + 0x05c8
                    (/home/db2inst1/sqllib/lib64/libdb2e.so.1)
    0x000003FF8FADD79E
    _Z21sqlnlsICUDateToSymbolPKhPh20sqlnlsDateTimeFormatP10sqlz_valu
    ePKcPi16sqlnlsUnicodeVerP15sqlnlsUDATChain + 0x00ba
                    (/home/db2inst1/sqllib/lib64/libdb2e.so.1)
    0x000003FF8FAD95C6 sqlvVarcharFormat + 0x0e26
                    (/home/db2inst1/sqllib/lib64/libdb2e.so.1)
    0x000003FF8EAD0AD2
    _Z22sqlriVarcharFormatEvalP8sqlrr_cbP10sqlz_valueS2_S2_S2_S2_S2_
    + 0x02e6
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * ALL                                                          *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to Db2 11.1 Mod 4 Fixpack 5 or higher                *
    ****************************************************************
    

Problem conclusion

  • First fixed in Db2 11.1 Mod 4 Fixpack 5
    

Temporary fix

Comments

APAR Information

  • APAR number

    IT26954

  • 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

    2018-11-13

  • Closed date

    2020-01-16

  • Last modified date

    2020-01-16

  • 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

  • RB10 PSN

       UP

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

Document Information

Modified date:
16 January 2020