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

DB2 Version 10.1 Fix Pack 2 for Linux, UNIX, and Windows

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 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