DB2 FOR LUW / DB2FORLUW / A10 - DB2

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)

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

DB2 Version 10.1 Fix Pack 2 for Linux, UNIX, and Windows
 DB2 Version 10.1 Fix Pack 3 for Linux, UNIX, and Windows
 DB2 Version 10.1 Fix Pack 4 for Linux, UNIX, and Windows
 DB2 Version 10.1 Fix Pack 3a for Linux, UNIX, and Windows
 DB2 Version 10.1 Fix Pack 6 for Linux, UNIX, and Windows
 

Upgrade to v10.1.2

keiner bekannt / siehe Local-Fix

Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:

28.11.2012
17.12.2012
17.12.2012