|
Problem IC75340
|
Status: Closed |
VLDB REDISTRIBUTION TRAP AT FUNCTION SQLUCCDOUBLYLINKEDLIST |
| product: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| Problem description: |
ON a VLDB environment after customers add/reduce the node number
and run redistribute command the DB2 instance could crash at
function sqlucCDoublyLinkedList due to a rare time hole.
Here is the possible callstack of the crashed EDU.
0x09000000061C2F84
zNext__Q2_22sqlucCDoublyLinkedList14sqlucCIteratorFPP12sqlucCObj
ect +
0x48
0x0900000006208A50
zNext__33sqlucCMatchingTaskMessageIteratorFPP16sqlucCTQMMessageP
UlP18sql
ucIListIteratorP13sqlucCTQMUser + 0x2A0
0x0900000006207918
zCheckOutNextMessageInternal__13sqlucCTQMUserFPP16sqlucCTQMMessa
gePUli +
0x270
0x0900000006206280
zCheckOutNextMessage__22sqlucCTaskQueueManagerFP13sqlucCTQMUserP
P16sqluc
CTQMMessagePUli + 0x140
0x0900000006203890 zDispatch__20sqlucCTaskDispatcherFUli + 0x318
0x0900000006201EC8 iRun__20sqlurCWorkerSubAgentFv + 0x254
0x0900000005B3E628 sqlusSubAgentRouter__FP8sqeAgenti + 0x8CC
0x0900000005B33B2C sqleSubRequestRouter__FP8sqeAgentPUiT2 +
0x11E0
0x0900000005B2F4A4 sqleProcessSubRequest__FP8sqeAgent + 0x120
0x09000000064B90B0 RunEDU__8sqeAgentFv + 0x314
0x0900000004F2DF70 EDUDriver__9sqzEDUObjFv + 0x78
0x0900000004F7672C sqloEDUEntry + 0x57C
</StackTrace> |
| Problem Summary: |
ON a VLDB environment after customers add/reduce the node number
and run redistribute command the DB2 instance could crash at
function sqlucCDoublyLinkedList due to a rare time hole.
Here is the possible callstack of the crashed EDU.
0x09000000061C2F84
zNext__Q2_22sqlucCDoublyLinkedList14sqlucCIteratorFPP12sqlucCObj
ect +
0x48
0x0900000006208A50
zNext__33sqlucCMatchingTaskMessageIteratorFPP16sqlucCTQMMessageP
UlP18sql
ucIListIteratorP13sqlucCTQMUser + 0x2A0
0x0900000006207918
zCheckOutNextMessageInternal__13sqlucCTQMUserFPP16sqlucCTQMMessa
gePUli +
0x270
0x0900000006206280
zCheckOutNextMessage__22sqlucCTaskQueueManagerFP13sqlucCTQMUserP
P16sqluc
CTQMMessagePUli + 0x140
0x0900000006203890 zDispatch__20sqlucCTaskDispatcherFUli + 0x318
0x0900000006201EC8 iRun__20sqlurCWorkerSubAgentFv + 0x254
0x0900000005B3E628 sqlusSubAgentRouter__FP8sqeAgenti + 0x8CC
0x0900000005B33B2C sqleSubRequestRouter__FP8sqeAgentPUiT2 +
0x11E0
0x0900000005B2F4A4 sqleProcessSubRequest__FP8sqeAgent + 0x120
0x09000000064B90B0 RunEDU__8sqeAgentFv + 0x314
0x0900000004F2DF70 EDUDriver__9sqzEDUObjFv + 0x78
0x0900000004F7672C sqloEDUEntry + 0x57C
</StackTrace> |
| Local Fix: |
Restart the instance and issuing redistribute command again.
That could avoid that timing hole. |
| available fix packs: |
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 6 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 7 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 9a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows
|
| Solution |
This APAR is first fixed on the DB2 v9.7fp4 |
| Workaround |
Restart the instance and issuing redistribute command again.
That could avoid that timing hole. |
| BUG-Tracking |
forerunner : APAR is sysrouted TO one or more of the following: IC75342
follow-up : |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 29.03.2011
29.04.2011
29.04.2011 |
| Problem solved at the following versions (IBM BugInfos) |
9.7.FP4
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.7.0.4
|
 |
