|
Problem IC61822
|
Status: Closed |
DB2 INSTANCE CRASH DURING CURSOR LOAD FROM NICKNAME ON A DB2_TWO_PHASE_COMMIT ENABLED SERVER |
| product: |
DB2 FOR LUW / DB2FORLUW / 910 - 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 using Two phase commit *
****************************************************************
* 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
* + 0x140C *
****************************************************************
* RECOMMENDATION: *
* Upgrade to DB2 v9.1 FP8 or newer for the fix to this issue. *
**************************************************************** |
| Local Fix: |
Disable two phase commit for the server. |
| available fix packs: |
DB2 Version 9.1 Fix Pack 8 for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 9 for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 10 for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 11 for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 12 for Linux, UNIX and Windows
|
| Solution |
APAR IC61822 is created to resolve this issue. |
| Workaround |
Disable two phase commit for the server. |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 01.07.2009
12.10.2009
12.10.2009 |
| Problem solved at the following versions (IBM BugInfos) |
9.1.FP8
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.1.0.8
|
 |
