IC88651: INSTANCE MAY TRAP WITH SIGNAL 11 IN ICU UDAT_PARSE WHILE RUNNING LOAD

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • If  table contains a generated column to_char or
    dayname/monthname scalar function, instance may trap wile
    processing load.
    
    The APAR is applicable for:DB2 Server releases:
    v9.7.5, v9.7.6
    
    For example: If table created as:
    create table myschema.scalarfun_T1972 ( ts timestamp , c2
    GENERATED AS ( to_char ( TS , 'J' , 'en_US' ) ) );
    
    
    Stack Trace back:
    ICU function after udat_parse may vary.
    0x00002AAAB8979EFF
    _ZN7icu_3_88Calendar17computeZoneOffsetEdiR10UErrorCode + 0x0049
    
      (/home/hotel47/anjuk/sqllib/lib64/libicui18ndb2.so.38)
    0x00002AAAB8979FE8
    _ZN7icu_3_88Calendar11computeTimeER10UErrorCode + 0x00d4
      (/home/hotel47/anjuk/sqllib/lib64/libicui18ndb2.so.38)
    0x00002AAAB897B21C
    _ZN7icu_3_88Calendar10updateTimeER10UErrorCode + 0x001e
      (/home/hotel47/anjuk/sqllib/lib64/libicui18ndb2.so.38)
    0x00002AAAB897B299
    _ZNK7icu_3_88Calendar15getTimeInMillisER10UErrorCode + 0x003f
      (/home/hotel47/anjuk/sqllib/lib64/libicui18ndb2.so.38)
    0x00002AAAB894ABA2
    _ZNK7icu_3_810DateFormat5parseERKNS_13UnicodeStringERNS_13ParseP
    ositionE + 0x00aa
      (/home/hotel47/anjuk/sqllib/lib64/libicui18ndb2.so.38)
    0x00002AAAB8959782 udat_parse_3_8 + 0x00bc
      (/home/hotel47/anjuk/sqllib/lib64/libicui18ndb2.so.38)
    0x00002AAAABF28E18
    _Z28sqlnlsICUDateToSymbol_U500R1PKhPh20sqlnlsDateTimeFormatP10sq
    lz_valuePKcPiP15sqlnlsUDATChain + 0x0af8
      (/home/hotel47/anjuk/sqllib/lib64/libdb2e.so.1)
    0x00002AAAAFE4D417
    _Z21sqlnlsICUDateToSymbolPKhPh20sqlnlsDateTimeFormatP10sqlz_valu
    ePKcPi16sqlnlsUnicodeVerP15sqlnlsUDATChain + 0x007b
      (/home/hotel47/anjuk/sqllib/lib64/libdb2e.so.1)
    0x00002AAAAFE3FEEC sqlvVarcharFormat + 0x2ae0
      (/home/hotel47/anjuk/sqllib/lib64/libdb2e.so.1)
    0x00002AAAAF03F27F _Z18sqlriVarcharFormatP8sqlrr_cb + 0x07bb
      (/home/hotel47/anjuk/sqllib/lib64/libdb2e.so.1)
    0x00002AAAAEFA12BF _Z15sqlriExecThreadP8sqlrr_cbP12sqlri_opparm
    + 0x0561
      (/home/hotel47/anjuk/sqllib/lib64/libdb2e.so.1)
    0x00002AAAAF05394F _Z15sqlriSectInvokeP8sqlrr_cbP12sqlri_opparm
    + 0x09fb
      (/home/hotel47/anjuk/sqllib/lib64/libdb2e.so.1)
    0x00002AAAAEB6B634 _Z19sqlriExecOpenThreadP8sqlrr_cb + 0x04b4
      (/home/hotel47/anjuk/sqllib/lib64/libdb2e.so.1)
    0x00002AAAAF89D626
    _ZN24sqluCGenColDataFormatter15iExecuteSectionEP8sqeAgent +
    0x03e4
      (/home/hotel47/anjuk/sqllib/lib64/libdb2e.so.1)
    0x00002AAAAF8975E5
    _ZN14sqluCGenColMgr21iProcessGeneratedColsEP8sqeAgentP16sqluCCat
    alogInfoP13SQLUCACB_TYPEP17SQLU_FORMATTER_CBPP10SQLD_VALUEPmiRiS
    C_Pi + 0x0d37
      (/home/hotel47/anjuk/sqllib/lib64/libdb2e.so.1)
    0x00002AAAAF8EE970 address: 0x00002AAAAF8EE970 ; dladdress:
    0x00002AAAAACE0000 ; offset in lib: 0x0000000004C0E970 ;
      (/home/hotel47/anjuk/sqllib/lib64/libdb2e.so.1)
    0x00002AAAAF8E9889 _ZN14sqluCFormatter4iRunEv + 0x29f9
      (/home/hotel47/anjuk/sqllib/lib64/libdb2e.so.1)
    0x00002AAAAF9F1E05 _Z17sqluLoadEDUDriverPhj + 0x1b9d
      (/home/hotel47/anjuk/sqllib/lib64/libdb2e.so.1)
    0x00002AAAAE795917 sqloEDUEntry + 0x070f
      (/home/hotel47/anjuk/sqllib/lib64/libdb2e.so.1)
    0x00002AAAAABCD193 address: 0x00002AAAAABCD193 ; dladdress:
    0x00002AAAAABC7000 ; offset in lib: 0x0000000000006193 ;
      (/lib64/libpthread.so.0)
    0x00002AAAB378BDFD __clone + 0x006d
      (/lib64/libc.so.6)
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * ALL                                                          *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to v10.1.2                                           *
    ****************************************************************
    

Problem conclusion

  • Upgrade to v10.1.2
    

Temporary fix

Comments

APAR Information

  • APAR number

    IC88651

  • Reported component name

    DB2 FOR LUW

  • Reported component ID

    DB2FORLUW

  • Reported release

    A10

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2012-11-28

  • Closed date

    2012-12-17

  • Last modified date

    2012-12-17

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

    IC86273

  • 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

  • R910 PSN

       UP

  • R910 PSY

       UP



Rate this page:

(0 users)Average rating

Add comments

Document information


More support for:

DB2 for Linux, UNIX and Windows

Software version:

10.1

Reference #:

IC88651

Modified date:

2012-12-17

Translate my page

Machine Translation

Content navigation