View Single Post

   
  #1 (permalink)  
Old 04-20-2008, 04:10 PM
Laurie Gustin
 
Posts: n/a
Default 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

Reply With Quote