home clear 64x64
en blue 200x116 de orange 200x116 info letter User
suche 36x36
Neueste VersionenFixList
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
Haben Sie Probleme? - Kontaktieren Sie uns.
Kostenlos registrieren anmeldung-x26
Kontaktformular kontakt-x26

DB2 - Problembeschreibung

Problem IC75340 Status: Geschlossen

VLDB REDISTRIBUTION TRAP AT FUNCTION SQLUCCDOUBLYLINKEDLIST

Produkt:
DB2 FOR LUW / DB2FORLUW / 970 - DB2
Problembeschreibung:
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-Zusammenfassung:
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.
verfügbare FixPacks:
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

Lösung
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-Verfolgung
Vorgänger  : APAR is sysrouted TO one or more of the following: IC75342 
Nachfolger : 
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
29.03.2011
29.04.2011
29.04.2011
Problem behoben ab folgender Versionen (IBM BugInfos)
9.7.FP4
Problem behoben lt. FixList in der Version
9.7.0.4 FixList