| Neueste Versionen | FixList |
| 11.1.0.7 |
 |
| 10.5.0.9 |
|
| 10.1.0.6 |
|
| 9.8.0.5 |
|
| 9.7.0.11 |
|
| 9.5.0.10 |
|
| 9.1.0.12 |
|
| Haben Sie Probleme? - Kontaktieren Sie uns. | |
| Kostenlos registrieren |
|
| Kontaktformular |
|
DB2 - Problembeschreibung
| Problem IT07454 | Status: Geschlossen |
LOAD HANGS DUE TO LOAD RIDDER QUEUE FULL | |
| Produkt: | |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 | |
| Problembeschreibung: | |
A Load will hang and not able to be forced off (even after having been terminated). The symptons are: 1. db2lrid showing in db2pd -utilities output for the Load but not showing in db2pd -edus. 2. Ipcs ouput shows that there is a message queue full, which is likely the db2lrid queue. 3. Stacks for the threads show: db2lfrm0 waiting on db2lrid 32 (0) ossDumpStackTraceEx 33 (1) OSSTrapFile::dumpEx 34 (2) sqlo_trce 35 (3) sqloDumpDiagInfoHandler 36 (4) __PRETTY_FUNCTION__.5889 37 (5) msgsnd 38 (6) sqlowqueInternal 39 (7) sqlowque 40 (8) sqluWriteQueue 41 (9) sqluTellRidderNoMoreData 42 (10) squFrmTerm 43 (11) sqluCFormatter::iCleanUp 44 (12) sqluLoadEDUDriver 45 (13) sqloEDUEntry 46 (14) pthread_tryjoin_np 47 (15) clone Load agent is on msgsnd the same as the db2lfrmx db2lfrmx: 34 (0) ossDumpStackTraceEx 35 (1) OSSTrapFile::dumpEx 36 (2) sqlo_trce 37 (3) sqloDumpDiagInfoHandler 38 (4) __PRETTY_FUNCTION__.5889 39 (5) msgsnd 40 (6) sqlowqueInternal 41 (7) sqlowque 42 (8) sqluWriteQueue 43 (9) sqlulPutBuff 44 (10) sqluRiddifyRecords 45 (11) sqluGetAndFormatRecords 46 (12) sqluCFormatter::iRun 47 (13) sqluLoadEDUDriver 48 (14) sqloEDUEntry 49 (15) pthread_tryjoin_np 50 (16) clone Load agent: 72 (0) ossDumpStackTraceEx 73 (1) OSSTrapFile::dumpEx 74 (2) sqlo_trce 75 (3) sqloDumpDiagInfoHandler 76 (4) __PRETTY_FUNCTION__.5889 77 (5) msgsnd 78 (6) sqlowqueInternal 79 (7) sqlowque 80 (8) sqluWriteQueue 81 (9) sqlulSndTermMsg 82 (10) sqlulTerminate 83 (11) sqlulPrcErr 84 (12) sqlulFRMResponse 85 (13) sqlulPollMsg 86 (14) sqluvload 87 (15) call_sqluvload 88 (16) sqluLoadPartition 89 (17) sqlu_register_table_load 90 (18) sqluvtld_route_in 91 (19) sqlesrvr 92 (20) sqleMappingFnServer 93 (21) sqlerKnownProcedure 94 (22) sqlerCallDL 95 (23) sqljs_ddm_excsqlstt 96 (24) sqljsParseRdbAccessed 97 (25) sqljsParse 98 (26) sqljsSqlam 99 (27) sqljsDriveRequests 100 (28) sqljsDrdaAsInnerDriver 101 (29) sqljsDrdaAsDriver 102 (30) sqeAgent::RunEDU 103 (31) sqzEDUObj::EDUDriver 104 (32) sqlzRunEDU 105 (33) sqloEDUEntry 106 (34) pthread_tryjoin_np 107 (35) clone | |
| Problem-Zusammenfassung: | |
**************************************************************** * USERS AFFECTED: * * ALL * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to DB2 Version 9.7 and Fix Pack 11 * **************************************************************** | |
| Local-Fix: | |
| Lösung | |
Problem was first fixed in DB2 Version 9.7 and Fix Pack 11 | |
| Workaround | |
keiner bekannt / siehe Local-Fix | |
| Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 03.03.2015 08.10.2015 08.10.2015 |
| Problem behoben ab folgender Versionen (IBM BugInfos) | |
9.7. | |
| Problem behoben lt. FixList in der Version | |
| 9.7.0.11 |
|
