Re: Replication Newbie Question

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 serverSERVER 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