Replication problem

Informix 11.7FC2 Solaris 10 Hi All, I am getting the following message in the online log: "09:29:20 CDR RQM: rqmSbOpen() failed for KEY (18/67873/0x29fc198/0x0) dberror=12097 thread 116 queue trg_send" When I do onstat -g rqm brief I can see that the transaction to one of the servers grp_24_kzn is not going through. onstat -g rqm brief IBM Informix Dynamic Server Version 11.70.FC2 -- On-Line -- Up 00:14:15 --10649600 Kbytes Queue trg_send (all totals approximate) # Txns In Memory: 115069 Server grp_24_kzn (24) # txns in queue: 115069 Server grp_23_north (23) # txns in queue: 2 Server grp_05_iwqs (5) # txns in queue: 2 Server grp_21_mpum (21) # txns in queue: 2 Server grp_25_ncape (25) # txns in queue: 2 Server grp_15_gaut (15) # txns in queue: 2 Server grp_26_ecape (26) # txns in queue: 2 Server grp_20_nwest (20) # txns in queue: 2 Server grp_08_headq (8) # txns in queue: 2 Server grp_22_fs (22) # txns in queue: 1 Queue ack_send (all totals approximate) # Txns In Memory: 65 Queue trg_receive (all totals approximate) # Txns In Memory: 1 However cdr list serv shows that the connection is Active and connected. onstat -g rqm brief IBM Informix Dynamic Server Version 11.70.FC2 -- On-Line -- Up 00:14:15 --10649600 Kbytes Queue trg_send (all totals approximate) # Txns In Memory: 115069 Server grp_24_kzn (24) # txns in queue: 115069 Server grp_23_north (23) # txns in queue: 2 Server grp_05_iwqs (5) # txns in queue: 2 Server grp_21_mpum (21) # txns in queue: 2 Server grp_25_ncape (25) # txns in queue: 2 Server grp_15_gaut (15) # txns in queue: 2 Server grp_26_ecape (26) # txns in queue: 2 Server grp_20_nwest (20) # txns in queue: 2 Server grp_08_headq (8) # txns in queue: 2 Server grp_22_fs (22) # txns in queue: 1 Queue ack_send (all totals approximate) # Txns In Memory: 65 Queue trg_receive (all totals approximate) # Txns In Memory: 1 Can anyone tell me what is going on and what should I do to rectify this. Thanks

Hi, onstat -g rqm brief -r 1 | grep "grp_24_kzn (24)" to monitor the growingof the queue On server grp_24_kzn: cdr list repl to monitor that all replicates are ACTIVE on THAT server HTH, Reinhard. > -----Original Message----- > From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of FLIP > VAN WYNGAARDT > Sent: Thursday, June 23, 2011 9:37 AM > To: ids@iiug.org > Subject: Replication problem [24118] > > Informix 11.7FC2 > Solaris 10 > > Hi All, > > I am getting the following message in the online log: > > "09:29:20 CDR RQM: rqmSbOpen() failed for KEY (18/67873/0x29fc198/0x0) > dberror=12097 thread 116 queue trg_send" > > When I do onstat -g rqm brief I can see that the transaction to one of the > servers grp_24_kzn is not going through. > > onstat -g rqm brief> > IBM Informix Dynamic Server Version 11.70.FC2 -- On-Line -- Up 00:14:15 --> 10649600 Kbytes > > Queue trg_send (all totals approximate) > > # Txns In Memory: 115069 > > Server grp_24_kzn (24) # txns in queue: 115069 > > Server grp_23_north (23) # txns in queue: 2 > > Server grp_05_iwqs (5) # txns in queue: 2 > > Server grp_21_mpum (21) # txns in queue: 2 > > Server grp_25_ncape (25) # txns in queue: 2 > > Server grp_15_gaut (15) # txns in queue: 2 > > Server grp_26_ecape (26) # txns in queue: 2 > > Server grp_20_nwest (20) # txns in queue: 2 > > Server grp_08_headq (8) # txns in queue: 2 > > Server grp_22_fs (22) # txns in queue: 1 > > Queue ack_send (all totals approximate) > > # Txns In Memory: 65 > > Queue trg_receive (all totals approximate) > > # Txns In Memory: 1 > > However cdr list serv shows that the connection is Active and connected. > > onstat -g rqm brief> > IBM Informix Dynamic Server Version 11.70.FC2 -- On-Line -- Up 00:14:15 --> 10649600 Kbytes > > Queue trg_send (all totals approximate) > > # Txns In Memory: 115069 > > Server grp_24_kzn (24) # txns in queue: 115069 > > Server grp_23_north (23) # txns in queue: 2 > > Server grp_05_iwqs (5) # txns in queue: 2 > > Server grp_21_mpum (21) # txns in queue: 2 > > Server grp_25_ncape (25) # txns in queue: 2 > > Server grp_15_gaut (15) # txns in queue: 2 > > Server grp_26_ecape (26) # txns in queue: 2 > > Server grp_20_nwest (20) # txns in queue: 2 > > Server grp_08_headq (8) # txns in queue: 2 > > Server grp_22_fs (22) # txns in queue: 1 > > Queue ack_send (all totals approximate) > > # Txns In Memory: 65 > > Queue trg_receive (all totals approximate) > > # Txns In Memory: 1 > > Can anyone tell me what is going on and what should I do to rectify this. > > Thanks > > > ************************************************************************ ******* > Forum Note: Use "Reply" to post a response in the discussion forum.