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 |