Re: Data replication configuration

Jean-Francois wrote: > Hello, Hi, > > I am working on online 7.13 and I would like to monitor data replication. > > I know system tables sysdri and sysdrcb but I am looking for the place > where is stored if data replication is set or not. > > In fact, onstat -g dri gives the same piece of information if data > replication is configured on the instance and down and if DR has never > been set up at all for the instance. > > INFORMIX-OnLine Version 7.13.UC3 -- On-Line -- Up 16:41:01 -- 15088 > Kbytes > > Data Replication: > Type State Paired server Last DR CKPT (id/pg) > standard off -1 / -1 > If data replication configured for OnLine instance and that instance is primary, then you will see in the first line of onstat output -- OnLine (Prim) --. This means, that someone executed command: onmode -d primary <name_of_secondary> Paired server will be <name_of_secondary>. If instance is secondary, then you will see -- Read-Only (Sec) -- if everything is OK and replication started. Or -- <some_other_state> (Sec) -- if something wrong. This means that someone performed cold restore on secondary and executed command onmode -d secondary <name_of_primary> You can see online.log to find some previous actions regarding data replication. Lines must contain "DR:". If someone (your DBA) performed that actions, then you definitely should consult with him. > DRINTERVAL 30 > DRTIMEOUT 30 > DRAUTO 0 > DRLOSTFOUND /users/informix/dump/dr.lostfound> > Does somebody know how I can identify that the monitored instance has > been configured for data replication and that it is down ? > > Thanks for you help. > > Jean-Francois. Vardan -- vardan@sterling.ru Vardan Aroustamian Sterling Group, Moscow, Russia