DB2 - Problembeschreibung
Problem IC97637 | Status: Geschlossen |
Crash while executing query with LIKE operator using wildcard su ch as %% in as UTF-8 codepage supporting multi-byte characters. | |
Produkt: | |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 | |
Problembeschreibung: | |
DB2 might crash when you have query with LIKE operator using wild card such %pattern% in a mixed code page database i.e UTF 8. Db2diag.log and stack should look like this:- 2013-10-19-01.47.28.144072-420 I25330A824 LEVEL: Severe PID : 17498322 TID : 21335 PROC : db2sysc 0 INSTANCE: db2inst1 NODE : 000 DB : SAMPLE APPHDL : 0-27518 APPID: Local.AD0B.131021164313 AUTHID : DTUUSER1 EDUID : 21335 EDUNAME: db2agent (sample) 0 FUNCTION: DB2 UDB, relation data serv, sqlrr_dump_ffdc, probe:300 DATA #1 : SQLCA, PD_DB2_TYPE_SQLCA, 136 bytes sqlcaid : SQLCA sqlcabc: 136 sqlcode: 0 sqlerrml: 0 sqlerrmc: sqlerrp : SQL09076 sqlerrd : (1) 0x00000000 (2) 0x00000000 (3) 0x00000000 (4) 0x00000000 (5) 0x00000000 (6) 0x00000000 sqlwarn : (1) (2) (3) (4) (5) (6) (7) (8) (9) (10) (11) sqlstate: 2013-10-19-01.47.28.160493-420 I31550A940 LEVEL: Severe PID : 17498322 TID : 21335 PROC : db2sysc 0 INSTANCE: gdpd305 NODE : 000 DB : SAMPLE APPHDL : 0-27518 APPID: Local.AD0B.131021164313 AUTHID : DTUUSER1 EDUID : 21335 EDUNAME: db2agent (sample) 0 FUNCTION: DB2 UDB, relation data serv, sqlrr_dump_sibling, probe:140 MESSAGE : section stmt DATA #1 : Hexdump, 87 bytes 0x07800001F7C43C20 : 7365 6C65 6374 2063 6F75 6E74 282A 2920 select count(*) 0x07800001F7C43C30 : 6672 6F6D 2074 6574 6C78 3030 2E74 3331 from tetlx00.t31 0x07800001F7C43C40 : 3134 5F64 6473 5F70 6172 6D20 7768 6572 14_dds_parm wher 0x07800001F7C43C50 : 6520 5250 545F 5041 524D 5F46 554C 4C5F e RPT_PARM_FULL_ 0x07800001F7C43C60 : 5458 206C 696B 6520 2725 524C 545F 4558 TX like '%RLT_EX 0x07800001F7C43C70 : 505F 494E 4425 27 P_IND%' <StackTrace> sqlv_mixd_match__FPUcN21iN24PiT1 sqlv_mixd_short_substring__FPUciP15sqlv_subpatternP12sqlv_patter nPlPi sqlv_mixd_short_search__FP8sqlrr_cbP10sqlz_valueT2P12sqlv_patter nPl sqlv_mixd_short_search__FP8sqlrr_cbP10sqlz_valueT2P12sqlv_patter nPl@glue sqlri_like_short__FP8sqlrr_cb sqldEvalDataPred__FP13SQLD_DFM_WORKPUlP10SQLD_DPRED sqldReadNorm__FP13SQLD_DFM_WORKl sqldFetchNext__FP13SQLD_DFM_WORK sqldFetchNext__FP13SQLD_DFM_WORK@glueDAE sqldfrd__FP13SQLD_DFM_WORK sqldfrd__FP13SQLD_DFM_WORK@glue5BF sqldRowFetch__FP8sqeAgentP8SQLD_CCBUlT3PP10SQLD_VALUEP8SQLZ_RIDT 3P12SQLD_ID_LISTP9SQLP_LSN8 sqlritaSimplePerm__FP8sqlrr_cb sqlriSectInvoke__FP8sqlrr_cbP12sqlri_opparm sqlrr_process_fetch_request__FP14db2UCinterface sqlrr_open__FP14db2UCinterfaceP15db2UCCursorInfo sqljs_ddm_opnqry__FP14db2UCinterfaceP13sqljDDMObject sqljsParseRdbAccessed__FP13sqljsDrdaAsCbP13sqljDDMObjectP14db2UC interface sqljsParse.fdpr.clone.707__FP13sqljsDrdaAsCbP14db2UCinterfaceP8s qeAgentb sqljsSqlam__FP14db2UCinterfaceP8sqeAgentb sqljsDriveRequests__FP8sqeAgentP14db2UCconHandle sqljsDrdaAsInnerDriver__FP18SQLCC_INITSTRUCT_Tb sqljsDrdaAsDriver__FP18SQLCC_INITSTRUCT_T RunEDU__8sqeAgentFv EDUDriver__9sqzEDUObjFv sqloEDUEntry </StackTrace> | |
Problem-Zusammenfassung: | |
**************************************************************** * USERS AFFECTED: * * ALL * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to DB2 version 9.7 Fix Pack 9. * **************************************************************** | |
Local-Fix: | |
verfügbare FixPacks: | |
DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows | |
Lösung | |
Workaround | |
keiner bekannt / siehe Local-Fix | |
Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 13.11.2013 20.12.2013 20.12.2013 |
Problem behoben ab folgender Versionen (IBM BugInfos) | |
9.7.FP9 | |
Problem behoben lt. FixList in der Version | |
9.7.0.9 | |
9.7.0.9 |