|
Problem IC86273
|
Status: Closed |
INSTANCE MAY TRAP WITH SIGNAL 11 IN ICU UDAT_PARSE WHILE RUNNING LOAD |
| product: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| Problem 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) |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* DB2 LUW *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade server to v9.7.7 and v10.1.0.2 *
**************************************************************** |
| Local Fix: |
|
| available fix packs: |
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
|
| Solution |
Upgrade server to v9.7.7. |
| Workaround |
not known / see Local fix |
| BUG-Tracking |
forerunner : APAR is sysrouted TO one or more of the following: IC86328 IC88651
follow-up : |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 31.08.2012
20.10.2012
20.10.2012 |
| Problem solved at the following versions (IBM BugInfos) |
9.7.7
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.7.0.7
|
 |
