|
Problem IC97637
|
Status: Closed |
Crash while executing query with LIKE operator using wildcard su ch as %% in as UTF-8 codepage supporting multi-byte characters. |
| product: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| Problem description: |
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 Summary: |
****************************************************************
* USERS AFFECTED: *
* ALL *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to DB2 version 9.7 Fix Pack 9. *
**************************************************************** |
| Local Fix: |
|
| available fix packs: |
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 |
|
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 13.11.2013
20.12.2013
20.12.2013 |
| Problem solved at the following versions (IBM BugInfos) |
9.7.FP9
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.7.0.9
|
 |
| 9.7.0.9
|
|
