|
Problem IT07454
|
Status: Closed |
LOAD HANGS DUE TO LOAD RIDDER QUEUE FULL |
| product: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| Problem description: |
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 Summary: |
****************************************************************
* USERS AFFECTED: *
* ALL *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to DB2 Version 9.7 and Fix Pack 11 *
**************************************************************** |
| Local Fix: |
|
| Solution |
Problem was first fixed in DB2 Version 9.7 and Fix Pack 11 |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 03.03.2015
08.10.2015
08.10.2015 |
| Problem solved at the following versions (IBM BugInfos) |
9.7.
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.7.0.11
|
 |
