home clear 64x64
en blue 200x116 de orange 200x116 info letter User
suche 36x36
Neueste VersionenFixList
11.1.0.7 FixList
10.5.0.9 FixList
10.1.0.6 FixList
9.8.0.5 FixList
9.7.0.11 FixList
9.5.0.10 FixList
9.1.0.12 FixList
Haben Sie Probleme? - Kontaktieren Sie uns.
Kostenlos registrieren anmeldung-x26
Kontaktformular kontakt-x26

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
DB2 Version 9.7 Fix Pack 8 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 10 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 FixList