|
Problem IC62679
|
Status: Closed |
THE SQL FUNCTION "REPLACE" CAN CAUSE AN INSTANCE CRASH IF STMT_CONC DB CFG PARAMETER IS SET TO "LITERALS" |
| product: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| Problem description: |
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 Summary: |
****************************************************************
* 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 |
| available fix packs: |
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
|
| Solution |
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 |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 20.08.2009
21.12.2009
21.12.2009 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.7.0.1
|
 |
