|
Problem IC78687
|
Status: Closed |
DB2 MAY ABEND IN INSERT INTO A VIEW OR AN ALIAS TO A BLOB COLUMN DEFINED WITH A DEFAULT VALUE |
| product: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| Problem description: |
An INSERT statement into a view or an alias to a BLOB column
which is defined with a DEFAULT value may
cause DB2 to abend with the following call stack.
<StackTrace>
-------Frame------ ------Function + Offset------
0x0900000000548730 pthread_kill + 0xB0
0x0900000006FAA3EC sqloDumpEDU + 0x4C
0x0900000007279118 sqldDumpContext__FP9sqeBsuEduiN42PCcPvT2 +
0x138
0x090000000714D848 sqlrr_dump_ffdc__FP8sqlrr_cbiT2 + 0x6C8
0x0900000007146218 sqlzeDumpFFDC__FP8sqeAgentUiP5sqlcai + 0x58
0x0900000007146AF8 sqlzeSqlCode__FP8sqeAgentUiUlT2P5sqlcaiUsPc +
0x378
0x09000000071426E8 sqlrrSqlCode + 0x2C8
0x090000000764D5A8 sqlriMemValidate__FP8sqlrr_cbP9sqlri_shd +
0x388
0x090000000764EB5C sqlriValidateSection__FP8sqlrr_cb + 0x23C
0x0900000007659D98 sqlriSectInvoke__FP8sqlrr_cbP12sqlri_opparm +
0x558
0x0900000007F01D58 sqlrr_process_execute_request__FP8sqlrr_cbi +
0x1958
0x0900000009692384 sqlrr_execute__FP14db2UCinterfaceP9UCstpInfo
+ 0x5A4
0x090000000D26A0B4
sqljs_ddm_excsqlstt__FP14db2UCinterfaceP13sqljDDMObject + 0x5F4
0x090000000D261080
sqljsParseRdbAccessed__FP13sqljsDrdaAsCbP13sqljDDMObjectP14db2UC
interface
+ 0x1E0
0x090000000D25FB7C
sqljsParse__FP13sqljsDrdaAsCbP14db2UCinterfaceP8sqeAgentb +
0x21C
0x090000000817F5CC sqljsSqlam__FP14db2UCinterfaceP8sqeAgentb +
0x4AC
0x090000000818143C
sqljsDriveRequests__FP8sqeAgentP14db2UCconHandle + 0x15C
0x0900000008188534
sqljsDrdaAsInnerDriver__FP18SQLCC_INITSTRUCT_Tb + 0x474
0x090000000818A5FC sqljsDrdaAsDriver__FP18SQLCC_INITSTRUCT_T +
0x23C
0x090000000712C2C0 RunEDU__8sqeAgentFv + 0x440
0x090000000711BC1C EDUDriver__9sqzEDUObjFv + 0x19C
0x090000000711BF3C sqlzRunEDU__FPcUi + 0x3C
0x0900000006FB4764 sqloEDUEntry + 0x6A4 |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* ALL *
****************************************************************
* PROBLEM DESCRIPTION: *
* An INSERT statement into a view or an alias to a BLOB column *
* *
* which is defined with a DEFAULT value may *
* *
* cause DB2 to abend with the following call stack. *
* *
* *
* *
* <StackTrace> *
* *
* -------Frame------ ------Function + Offset------ *
* *
* 0x0900000000548730 pthread_kill + 0xB0 *
* *
* 0x0900000006FAA3EC sqloDumpEDU + 0x4C *
* *
* 0x0900000007279118 sqldDumpContext__FP9sqeBsuEduiN42PCcPvT2 *
* + *
* 0x138 *
* *
* 0x090000000714D848 sqlrr_dump_ffdc__FP8sqlrr_cbiT2 + 0x6C8 *
* *
* 0x0900000007146218 sqlzeDumpFFDC__FP8sqeAgentUiP5sqlcai + *
* 0x58 *
* 0x0900000007146AF8 *
* sqlzeSqlCode__FP8sqeAgentUiUlT2P5sqlcaiUsPc + *
* 0x378 *
* *
* 0x09000000071426E8 sqlrrSqlCode + 0x2C8 *
* *
* 0x090000000764D5A8 sqlriMemValidate__FP8sqlrr_cbP9sqlri_shd *
* + *
* 0x388 *
* *
* 0x090000000764EB5C sqlriValidateSection__FP8sqlrr_cb + 0x23C *
* *
* 0x0900000007659D98 *
* sqlriSectInvoke__FP8sqlrr_cbP12sqlri_opparm + *
* 0x558 *
* *
* 0x0900000007F01D58 *
* sqlrr_process_execute_request__FP8sqlrr_cbi + *
* 0x1958 *
* *
* 0x0900000009692384 *
* sqlrr_execute__FP14db2UCinterfaceP9UCstpInfo *
* + 0x5A4 *
* *
* 0x090000000D26A0B4 *
* *
* sqljs_ddm_excsqlstt__FP14db2UCinterfaceP13sqljDDMObject + *
* 0x5F4 *
* 0x090000000D261080 *
* *
* sqljsParseRdbAccessed__FP13sqljsDrdaAsCbP13sqljDDMObjectP14d *
* b2UC *
* interface *
* *
* + 0x1E0 *
* *
* 0x090000000D25FB7C *
* *
* sqljsParse__FP13sqljsDrdaAsCbP14db2UCinterfaceP8sqeAgentb + *
* *
* 0x21C *
* *
* 0x090000000817F5CC sqljsSqlam__FP14db2UCinterfaceP8sqeAgentb *
* + *
* 0x4AC *
* *
* 0x090000000818143C *
* *
* sqljsDriveRequests__FP8sqeAgentP14db2UCconHandle + 0x15C *
* *
* 0x0900000008188534 *
* *
* sqljsDrdaAsInnerDriver__FP18SQLCC_INITSTRUCT_Tb + 0x474 *
* *
* 0x090000000818A5FC sqljsDrdaAsDriver__FP18SQLCC_INITSTRUCT_T *
* + *
* 0x23C *
* *
* 0x090000000712C2C0 RunEDU__8sqeAgentFv + 0x440 *
* *
* 0x090000000711BC1C EDUDriver__9sqzEDUObjFv + 0x19C *
* *
* 0x090000000711BF3C sqlzRunEDU__FPcUi + 0x3C *
* *
* 0x0900000006FB4764 sqloEDUEntry + 0x6A4 *
****************************************************************
* RECOMMENDATION: *
* Upgraded to DB2 version 9.7 Fix Pack 5. *
**************************************************************** |
| Local Fix: |
Upgraded to DB2 version 9.7 Fix Pack 5 |
| available fix packs: |
DB2 Version 9.7 Fix Pack 5 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 6 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 7 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 9a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows
|
| Solution |
The problem first happens in DB2 version 9.7 Fix Pack 2. |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 15.09.2011
07.12.2011
07.12.2011 |
| Problem solved at the following versions (IBM BugInfos) |
9.7.FP2,
9.7.FP5
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.7.0.5
|
 |
