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 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
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
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 FixList
9.7.0.9 FixList