SEO

Check the queue stats using onstat -g rqm at source. And receive stats
using onstat -g rcv on target.
Although servers are active, check if replicates are active using 'cdr
list repl' and verify the state.

Regards,

Nilesh



"Laurie Gustin" <lgustin@utah.gov>
Sent by: informix-list-bounces@iiug.org
02/15/2007 09:46 AM

To
<informix-list@iiug.org>
cc

Subject
Replication Newbie Question






IDS10 FC5 HP-UX 11.11

I have a quick question about replication.

I have ER running between two servers and the queue on the sending server
just keeps getting larger. It appears that the 2 servers are
communicating, but how do I get the queue to write/flush so it doesnt just
keep getting bigger?

here are some outputs


$ cdr list server
SERVER ID STATE STATUS QUEUE CONNECTION CHANGED
-----------------------------------------------------------------------
g_psproda 1 Active Local 0
g_psprodr 21 Active Connected 86638846 Feb 15 08:02:36



weird but the cdr stats recv doesnt give me anything this morning

$ cdr stats recv

Receive Parallelism Statistics
Server Tot.Txn. Pending Active MaxPnd MaxAct AvgPnd AvgAct CommitRt

Receive Parallelism Statistics not available

Statistics by Source

Server Repl Txn Ins Del Upd Last Target Apply Last
Source Commit


Yes, I stopped and started CDR on the receiving server hoping to jump
start the sending of data... I know... that was dumb. Luckily, we arent
really using the psprodr server (I say it is a receiving server, even
though the replication is set up for update anywhere, all of the
updates/inserts are currently done on the psporda server)

Any hints you can give would be helpful.

Thanks.

Laurie

_______________________________________________
Informix-list mailing list
Informix-list@iiug.org
http://www.iiug.org/mailman/listinfo/informix-list