IDS Forum

RE: Replication problem

Posted By: Habichtsberg, Reinhard
Date: Friday, 24 June 2011, at 2:35 a.m.

In Response To: Replication problem (FLIP VAN WYNGAARDT)

Hi,

onstat -g rqm brief -r 1 | grep "grp_24_kzn (24)" to monitor the growing
of 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.

Messages In This Thread

• Replication problem
  FLIP VAN WYNGAARDT -- Thursday, 23 June 2011, at 3:36 a.m.
  • RE: Replication problem
    Habichtsberg, Reinhard -- Friday, 24 June 2011, at 2:35 a.m.

IDS Forum is maintained by Administrator with WebBBS 5.12.