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) |