|
Problem IT04843
|
Status: Closed |
QUERY AGAINST CDE TABLE(S) COULD HANG ON DB2 V10.5 FP4 |
| product: |
DB2 FOR LUW / DB2FORLUW / A50 - DB2 |
| Problem description: |
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 Summary: |
****************************************************************
* USERS AFFECTED: *
* CDE tables only *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Install this fix *
**************************************************************** |
| Local Fix: |
N/A |
| Solution |
Install this fix |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 09.10.2014
15.12.2014
15.12.2014 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 10.5.0.5
|
 |
