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 IC62679 Status: Geschlossen

THE SQL FUNCTION "REPLACE" CAN CAUSE AN INSTANCE CRASH IF
STMT_CONC DB CFG PARAMETER IS SET TO "LITERALS"

Produkt:
DB2 FOR LUW / DB2FORLUW / 970 - DB2
Problembeschreibung:
Statement using REPLACE SQL function can crash IF: 
Database is created with UCA500R1 collation 
AND 
STMT_CONC database parameter is set to LITERALS 
 
Possible stack: 
<StackTrace> 
-------Frame------ ------Function + Offset------ 
0x000000000000F414 ?unknown + 0x0 
0x0900000002F27568 sqlriReplaceCC__FP8sqlrr_cb + 0x9C 
0x09000000010DB148 sqlriSectInvoke__FP8sqlrr_cbP12sqlri_opparm + 
0x5A4 
0x0900000000FF4D70 
sqlrr_process_fetch_request__FP14db2UCinterface + 0x1D0 
0x0900000001093D24 
sqlrr_open__FP14db2UCinterfaceP15db2UCCursorInfo + 0xB6C 
0x09000000010B3600 
sqljs_ddm_opnqry__FP14db2UCinterfaceP13sqljDDMObject + 0xAA0 
0x09000000010B577C 
sqljsParseRdbAccessed__FP13sqljsDrdaAsCbP13sqljDDMObjectP14db2UC 
interface 
+ 0x7C 
0x09000000010B5588 
.sqljsParse.fdpr.clone.1__FP13sqljsDrdaAsCbP14db2UCinterface + 
0x330 
0x09000000010B7BEC @64@sqljsSqlam__FP14db2UCinterfaceP8sqeAgentb 
+ 0x44C 
0x0900000001EC159C 
@64@sqljsDriveRequests__FP8sqeAgentP14db2UCconHandle + 0x74 
0x0900000001B85F18 
@64@sqljsDrdaAsInnerDriver__FP18SQLCC_INITSTRUCT_Tb + 0x2D0 
0x0900000000FC0874 sqljsDrdaAsDriver__FP18SQLCC_INITSTRUCT_T + 
0xFC
Problem-Zusammenfassung:
**************************************************************** 
* USERS AFFECTED:                                              * 
* STMT_CONC set to ON and SQL FUNCTION "REPLACE"               * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* THE SQL FUNCTION "REPLACE" CAN CAUSE AN INSTANCE CRASH IF    * 
* STMT_CONC DB CFG PARAMETER IS SET TO "LITERALS".             * 
* Workaround: db2 update db cfg using STMT_CONC OFF            * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* THE SQL FUNCTION "REPLACE" CAN CAUSE AN INSTANCE CRASH IF    * 
* STMT_CONC DB CFG PARAMETER IS SET TO "LITERALS".             * 
* Workaround: db2 update db cfg using STMT_CONC OFF            * 
****************************************************************
Local-Fix:
Workaround: db2 update db cfg using STMT_CONC OFF
verfügbare FixPacks:
DB2 Version 9.7 Fix Pack 1 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 2 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 3 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 3a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 4 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 5 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 7 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 6 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 10 for Linux, UNIX, and Windows

Lösung
THE SQL FUNCTION "REPLACE" CAN CAUSE AN INSTANCE CRASH IF 
STMT_CONC DB CFG PARAMETER IS SET TO "LITERALS". 
Workaround: db2 update db cfg using STMT_CONC OFF
Workaround
keiner bekannt / siehe Local-Fix
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
20.08.2009
21.12.2009
21.12.2009
Problem behoben ab folgender Versionen (IBM BugInfos)
Problem behoben lt. FixList in der Version
9.7.0.1 FixList