Latest versionsfixlist
11.1.0.7 FixList
10.5.0.9 FixList
10.1.0.6 FixList
9.8.0.5 FixList
9.7.0.11 FixList
9.5.0.10 FixList
9.1.0.12 FixList
Have problems? - contact us.
Register for free anmeldung-x26
Contact form kontakt-x26

DB2 - Problem description

Problem IC75342 Status: Closed

VLDB REDISTRIBUTION TRAP AT FUNCTION SQLUCCDOUBLYLINKEDLIST

product:
DB2 FOR LUW / DB2FORLUW / 950 - 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:
**************************************************************** 
* USERS AFFECTED:                                              * 
* All                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 Version 9.5 Fix Pack 7                        * 
****************************************************************
Local Fix:
Restart the instance and issuing redistribute command again. 
That could avoid that timing hole.
Solution
First Fixed in DB2 Version 9.5 Fix Pack 7
Workaround
not known / see Local fix
Timestamps
Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :
29.03.2011
08.11.2012
08.11.2012
Problem solved at the following versions (IBM BugInfos)
9.5.FP7
Problem solved according to the fixlist(s) of the following version(s)