replication

Hello, Is there a command that will return what type of replication is being run? also, what is the best way to check that replication is in sync? i have run onstat -g dri but this seems to only tell me if it is turned on/off and the LAST DR CKPT values do not match between primary and secondary so I am assuming this is not it.. TIA!!

Hi, Check the last couple of checkpoints on the primary and secondary servers - they should be within seconds of each other (assuming the clocks on the two boxes are in sync). HTH -- Phil@oninit.com

tomL wrote: > > Is there a command that will return what type of replication is being > run? If you run onstat - then if you see something like: Informix Dynamic Server Version 7.31.UC5 -- On-Line (Prim) -- Up 62 days 20:28:42 -- 53248 Kbytes or Informix Dynamic Server Version 7.31.UC5 -- Fast Recovery (Sec) -- Up 17 days 00:39:00 -- 40960 Kbytes Then the server is either the Primary or the Secondary of a HR pair. I don't recall if there's any special note for enterprise replication - I don't have immediate access to an ER machine and it's been over a year since I had to go near 'em. However, there are definite threads allocated to the job so you should see references to "cdr" type processes in the onstat -g sch or some other onstat listing. You could try onstat -a | grep cdr - something should turn up. To be more certain about ER, check out the ER manuals. They are very good and suitable for learning. The first chapter or two should probably give you enough info to clearly detect the existence of ER. > also, what is the best way to check that replication is in sync? zzzzzt pass. Once again, ER does have statistical listings showing the size of the send and receive queues, but in the abcence of my memory, you'll either have to read the ER manuals or hope someone else answers. As for HR, I haven't really looked into it but surely there's a statistical listing you can get to look at the backlog. Once again, check out the manuals. Don't forget, the manuals are all available online in the Informix Answers Online CD which comes with just about every product box you receive. There's really no excuse for any programmer or administrator NOT to have all the relevant manuals installed on their PC or a file server nearby.