DB2 - Problembeschreibung
Problem IT04843 | Status: Geschlossen |
QUERY AGAINST CDE TABLE(S) COULD HANG ON DB2 V10.5 FP4 | |
Produkt: | |
DB2 FOR LUW / DB2FORLUW / A50 - DB2 | |
Problembeschreibung: | |
This is a rare hard to hit condition that can only occur on DB2 v10.5 FP4. It is identified by 3 stacks that must happen: Stack: ====================== 0x090000000010F994 thread_wait + 0x94 0x090000000115CAC4 sqloWaitEDUWaitPost + 0x504 0x0900000012F95804 wait__Q3_7ibm_cde8services13EventWaitPostFCiPUi + 0x734 0x09000000142418A8 waitForSubagentAndCheckForError__Q3_7ibm_cde5query9SchedulerFv + 0x88 0x090000001423BEF8 runSingleTableQuery__Q3_7ibm_cde5query9SchedulerFv + 0x678 0x090000001423B4C8 runQuery__Q3_7ibm_cde5query9SchedulerFv + 0x1D8 0x090000001423DD9C runSchedThreadTask__Q3_7ibm_cde5query9SchedulerFPvPi + 0x10C 0x0900000014253640 cdeEntryPointImpl__Q2_7ibm_cde5queryFP8sqeAgentPvT2 + 0xA0 0x09000000138EA394 startCdeSubagent__12cdeInterfaceFP8sqeAgent + 0xB4 0x090000000514AD48 sqlriInvokeCde__FP8sqlrr_cb + 0x48 0x090000000365ED28 sqlriSectInvoke__FP8sqlrr_cbP12sqlri_opparm + 0x628 0x09000000070CD47C sqlrr_smp_router__FP8sqlrr_cb + 0x47C 0x09000000070C9DE4 sqlrr_subagent_router__FP8sqeAgentP12SQLE_DB2RA_T + 0xF64 0x0900000001F732B4 sqleSubRequestRouter__FP8sqeAgentPUiPUl + 0x834 0x0900000001F6C224 sqleProcessSubRequest__FP8sqeAgent + 0x2944 0x09000000011754C0 RunEDU__8sqeAgentFv + 0x9A0 0x0900000001159218 EDUDriver__9sqzEDUObjFv + 0x2D8 0x09000000010AB604 sqloEDUEntry + 0x324 Stack: ====================== 0x090000000010F994 thread_wait + 0x94 0x090000000115CAC4 sqloWaitEDUWaitPost + 0x504 0x0900000012F95804 wait__Q3_7ibm_cde8services13EventWaitPostFCiPUi + 0x734 0x090000001424232C waitForBoundary__Q3_7ibm_cde5query9SchedulerFRQ2_3std6_PtritXTUi TlTPCUiTRCUiTPUiTRUi_PQ3_7ibm_cde5query17EvaluationRoutine + 0x51C 0x09000000142410C0 runThreadTask__Q3_7ibm_cde5query9SchedulerFPvPi + 0xCD0 0x0900000014253640 cdeEntryPointImpl__Q2_7ibm_cde5queryFP8sqeAgentPvT2 + 0xA0 0x09000000138EA394 startCdeSubagent__12cdeInterfaceFP8sqeAgent + 0xB4 0x090000000514AD48 sqlriInvokeCde__FP8sqlrr_cb + 0x48 0x090000000365ED28 sqlriSectInvoke__FP8sqlrr_cbP12sqlri_opparm + 0x628 0x09000000070CD47C sqlrr_smp_router__FP8sqlrr_cb + 0x47C 0x09000000070C9DE4 sqlrr_subagent_router__FP8sqeAgentP12SQLE_DB2RA_T + 0xF64 0x0900000001F732B4 sqleSubRequestRouter__FP8sqeAgentPUiPUl + 0x834 0x0900000001F6C224 sqleProcessSubRequest__FP8sqeAgent + 0x2944 0x09000000011754C0 RunEDU__8sqeAgentFv + 0x9A0 0x0900000001159218 EDUDriver__9sqzEDUObjFv + 0x2D8 0x09000000010AB604 sqloEDUEntry + 0x324 Stack: ====================== 0x090000000010F994 thread_wait + 0x94 0x090000000115CAC4 sqloWaitEDUWaitPost + 0x504 0x0900000012F95804 wait__Q3_7ibm_cde8services13EventWaitPostFCiPUi + 0x734 0x0900000014240904 runThreadTask__Q3_7ibm_cde5query9SchedulerFPvPi + 0x514 0x0900000014253640 cdeEntryPointImpl__Q2_7ibm_cde5queryFP8sqeAgentPvT2 + 0xA0 0x09000000138EA394 startCdeSubagent__12cdeInterfaceFP8sqeAgent + 0xB4 0x090000000514AD48 sqlriInvokeCde__FP8sqlrr_cb + 0x48 0x090000000365ED28 sqlriSectInvoke__FP8sqlrr_cbP12sqlri_opparm + 0x628 0x09000000070CD47C sqlrr_smp_router__FP8sqlrr_cb + 0x47C 0x09000000070C9DE4 sqlrr_subagent_router__FP8sqeAgentP12SQLE_DB2RA_T + 0xF64 0x0900000001F732B4 sqleSubRequestRouter__FP8sqeAgentPUiPUl + 0x834 0x0900000001F6C224 sqleProcessSubRequest__FP8sqeAgent + 0x2944 0x09000000011754C0 RunEDU__8sqeAgentFv + 0x9A0 0x0900000001159218 EDUDriver__9sqzEDUObjFv + 0x2D8 0x09000000010AB604 sqloEDUEntry + 0x324 | |
Problem-Zusammenfassung: | |
**************************************************************** * USERS AFFECTED: * * CDE tables only * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Install this fix * **************************************************************** | |
Local-Fix: | |
N/A | |
Lösung | |
Install this fix | |
Workaround | |
keiner bekannt / siehe Local-Fix | |
Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 09.10.2014 15.12.2014 15.12.2014 |
Problem behoben ab folgender Versionen (IBM BugInfos) | |
Problem behoben lt. FixList in der Version | |
10.5.0.5 |