DB2 - Problembeschreibung
Problem IC61822 | Status: Geschlossen |
DB2 INSTANCE CRASH DURING CURSOR LOAD FROM NICKNAME ON A DB2_TWO_PHASE_COMMIT ENABLED SERVER | |
Produkt: | |
DB2 FOR LUW / DB2FORLUW / 910 - DB2 | |
Problembeschreibung: | |
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-Zusammenfassung: | |
**************************************************************** * 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. | |
verfügbare FixPacks: | |
DB2 Version 9.1 Fix Pack 8 for Linux, UNIX and Windows | |
Lösung | |
APAR IC61822 is created to resolve this issue. | |
Workaround | |
Disable two phase commit for the server. | |
Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 01.07.2009 12.10.2009 12.10.2009 |
Problem behoben ab folgender Versionen (IBM BugInfos) | |
9.1.FP8 | |
Problem behoben lt. FixList in der Version | |
9.1.0.8 |