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 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 FixList
This site uses cookies to make it easier for us to provide you with our services. By using our site you agree to the use of cookies.