DB2 - Problembeschreibung
Problem IC86273 | Status: Geschlossen |
INSTANCE MAY TRAP WITH SIGNAL 11 IN ICU UDAT_PARSE WHILE RUNNING LOAD | |
Produkt: | |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 | |
Problembeschreibung: | |
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) | |
Problem-Zusammenfassung: | |
**************************************************************** * USERS AFFECTED: * * DB2 LUW * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade server to v9.7.7 and v10.1.0.2 * **************************************************************** | |
Local-Fix: | |
verfügbare FixPacks: | |
DB2 Version 9.7 Fix Pack 7 for Linux, UNIX, and Windows | |
Lösung | |
Upgrade server to v9.7.7. | |
Workaround | |
keiner bekannt / siehe Local-Fix | |
Bug-Verfolgung | |
Vorgänger : APAR is sysrouted TO one or more of the following: IC86328 IC88651 Nachfolger : | |
Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 31.08.2012 20.10.2012 20.10.2012 |
Problem behoben ab folgender Versionen (IBM BugInfos) | |
9.7.7 | |
Problem behoben lt. FixList in der Version | |
9.7.0.7 |