home clear 64x64
en blue 200x116 de orange 200x116 info letter User
suche 36x36
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)