|
Problem IC61856
|
Status: Closed |
DB2 INSTANCE CRASH DURING CURSOR LOAD FROM NICKNAME ON A DB2_TWO_PHASE_COMMIT ENABLED SERVER |
| product: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| Problem description: |
DB2 instance crashes during load cursor from a nickname on a
DB2_TWO_PHASE_COMMIT enabled server. The trapping callstack is
similar to the below:
-------Frame------ ------Function + Offset------
0x0900000179E530CC
pGetCatalogInfo__26sqluCLoadRequestDescriptorFv + 0xC
0x0900000179E531D8 sqluSetLoadQueryTableState__FUi + 0x98
0x090000017A413ABC sqluCommitCallBack__Fv + 0x2FC
0x09000001777441C8
sqlrrcom_dps__FP8sqlrr_cbiT2P15SQLXA_CALL_INFO + 0x6A8
0x0900000177744DC0 sqlrrcom__FP8sqlrr_cbiT2 + 0x500
0x0900000177CC9164 sqlrr_commit__FP14db2UCinterface + 0x1A4
0x0900000179C25034 sqluv_commit__FP8sqeAgentPiP5sqlcai + 0x274
0x0900000179E50EBC sqluqagt__FP12SQLE_DB2RA_T + 0x8FC
0x09000001768C045C sqlesrvr__FP14db2UCinterface + 0x14FC
0x09000001768F36F8 sqleMappingFnServer__FP5sqldaP5sqlca + 0xFF8
0x0900000176FDE54C
sqlerKnownProcedure__FiPcPiP5sqldaT4P13sqlerFmpTableP8sqeAgentP5
sqlca
+ 0x140C
0x0900000176F977B4 sqlerCallDL__FP14db2UCinterfaceP9UCstpInfo +
0x1554
0x090000017C251718
sqljs_ddm_excsqlstt__FP14db2UCinterfaceP13sqljDDMObject + 0x458
0x090000017C21AA98
sqljsParseRdbAccessed__FP13sqljsDrdaAsCbP13sqljDDMObjectP14db2UC
interface
+ 0x1D8
0x090000017C219A14
sqljsParse__FP13sqljsDrdaAsCbP14db2UCinterface + 0x1F4
0x090000017C20944C sqljsSqlam__FP14db2UCinterfaceP8sqeAgentb +
0x3EC
0x090000017C20AABC
sqljsDriveRequests__FP8sqeAgentP14db2UCconHandle + 0x15C
0x090000017C21074C
sqljsDrdaAsInnerDriver__FP18SQLCC_INITSTRUCT_Tb + 0x2EC
0x090000017C210C60 sqljsDrdaAsDriver__FP18SQLCC_INITSTRUCT_T +
0x100
0x0900000176690F0C RunEDU__8sqeAgentFv + 0x3AC |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* Users who load from cursor from a nickname on a *
* DB2_TWO_PHASE_COMMIT enabled server *
****************************************************************
* PROBLEM DESCRIPTION: *
* DB2 instance crashes during load cursor from a nickname on a *
* *
* DB2_TWO_PHASE_COMMIT enabled server. The trapping callstack *
* is *
* similar to the below: *
* *
* -------Frame------ ------Function + Offset------ *
* *
* 0x0900000179E530CC *
* *
* pGetCatalogInfo__26sqluCLoadRequestDescriptorFv + 0xC *
* *
* 0x0900000179E531D8 sqluSetLoadQueryTableState__FUi + 0x98 *
* *
* 0x090000017A413ABC sqluCommitCallBack__Fv + 0x2FC *
* *
* 0x09000001777441C8 *
* *
* sqlrrcom_dps__FP8sqlrr_cbiT2P15SQLXA_CALL_INFO + 0x6A8 *
* *
* 0x0900000177744DC0 sqlrrcom__FP8sqlrr_cbiT2 + 0x500 *
* *
* 0x0900000177CC9164 sqlrr_commit__FP14db2UCinterface + 0x1A4 *
* *
* 0x0900000179C25034 sqluv_commit__FP8sqeAgentPiP5sqlcai + *
* 0x274 *
* 0x0900000179E50EBC sqluqagt__FP12SQLE_DB2RA_T + 0x8FC *
* *
* 0x09000001768C045C sqlesrvr__FP14db2UCinterface + 0x14FC *
* *
* 0x09000001768F36F8 sqleMappingFnServer__FP5sqldaP5sqlca + *
* 0xFF8 *
* 0x0900000176FDE54C *
* *
* sqlerKnownProcedure__FiPcPiP5sqldaT4P13sqlerFmpTableP8sqeAgent
* sqlca *
* *
* + 0x140C *
* *
* 0x0900000176F977B4 *
* sqlerCallDL__FP14db2UCinterfaceP9UCstpInfo + *
* 0x1554 *
* *
* 0x090000017C251718 *
* *
* sqljs_ddm_excsqlstt__FP14db2UCinterfaceP13sqljDDMObject + *
* 0x458 *
* 0x090000017C21AA98 *
* *
* sqljsParseRdbAccessed__FP13sqljsDrdaAsCbP13sqljDDMObjectP14db2
* interface *
* *
* + 0x1D8 *
* *
* 0x090000017C219A14 *
* *
* sqljsParse__FP13sqljsDrdaAsCbP14db2UCinterface + 0x1F4 *
* *
* 0x090000017C20944C sqljsSqlam__FP14db2UCinterfaceP8sqeAgentb *
* + *
* 0x3EC *
* *
* 0x090000017C20AABC *
* *
* sqljsDriveRequests__FP8sqeAgentP14db2UCconHandle + 0x15C *
* *
* 0x090000017C21074C *
* *
* sqljsDrdaAsInnerDriver__FP18SQLCC_INITSTRUCT_Tb + 0x2EC *
* *
* 0x090000017C210C60 sqljsDrdaAsDriver__FP18SQLCC_INITSTRUCT_T *
* + *
* 0x100 *
* *
* 0x0900000176690F0C RunEDU__8sqeAgentFv + 0x3AC *
****************************************************************
* RECOMMENDATION: *
* Upgrade to DB2 v9.7 FP1 or newer *
**************************************************************** |
| Local Fix: |
Disable two phase commit for the server. |
| 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 |
|
| Workaround |
Disable DB2_TWO_PHASE_COMMIT |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 02.07.2009
21.12.2009
21.12.2009 |
| Problem solved at the following versions (IBM BugInfos) |
9.7.FP1
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.7.0.1
|
 |
