HDR setup problem

HI Informix gurus, I am facing a problem while setting up HDR replication between Informix databases running on windows 2000. Below mentioned error I am getting in my log file:- 17:37:45 DR: Primary to Primary 17:37:45 DR: new type = primary, secondary server name = ol_shaileshbackup 17:37:45 DR: Cannot connect to secondary server 17:37:45 DR: Turned off on primary server Following are my setps , which I followed to setup HDR:- 1. Level 0 backup on primary server(ol_shailesh). 2. Below mentioned are the entries made in the sqlhosts file of the primary server. ol_shailesh onsoctcp 10.8.87.36 pri ol_shaileshbackup onsoctcp 10.8.87.80 sec3. In the services file of the primary server made following entry:- pri 1526/tcp #ol_shailesh 4. Run the command "onmode -d primary ol_shaileshbackup" 5. Restored level 0 backup on the secondary server. Using command "ontape -p" 6. Below mentioned are the entry made in the sqlhosts file of secondary server. ol_shailesh onsoctcp 10.8.87.36 pri ol_shaileshbackup onsoctcp 10.8.87.80 sec7. In the services file of secondary server made following entry:- sec 1526/tcp #ol_shaileshbackup 8. Run the command "onmode -d secondary ol_shailesh" Please go through it and suggest me with any missing or addtional steps. Thanks & Regards, Shailesh M

I think you must use the same service name in primary and secondary server "pri or sec in the both servers" Best Regards M. AFEILAL "Shailesh.Mo...." <Shailesh.More@ril. com> A Envoyé par : ids@iiug.org forum.subscriber@ii cc ug.org Objet HDR setup problem [2839] 17/04/2004 12:20 HI Informix gurus, I am facing a problem while setting up HDR replication between Informix databases running on windows 2000. Below mentioned error I am getting in my log file:- 17:37:45 DR: Primary to Primary 17:37:45 DR: new type = primary, secondary server name = ol_shaileshbackup 17:37:45 DR: Cannot connect to secondary server 17:37:45 DR: Turned off on primary server Following are my setps , which I followed to setup HDR:- 1. Level 0 backup on primary server(ol_shailesh). 2. Below mentioned are the entries made in the sqlhosts file of the primary server. ol_shailesh onsoctcp 10.8.87.36 pri ol_shaileshbackup onsoctcp 10.8.87.80 sec3. In the services file of the primary server made following entry:- pri 1526/tcp #ol_shailesh 4. Run the command "onmode -d primary ol_shaileshbackup" 5. Restored level 0 backup on the secondary server. Using command "ontape -p" 6. Below mentioned are the entry made in the sqlhosts file of secondary server. ol_shailesh onsoctcp 10.8.87.36 pri ol_shaileshbackup onsoctcp 10.8.87.80 sec7. In the services file of secondary server made following entry:- sec 1526/tcp #ol_shaileshbackup 8. Run the command "onmode -d secondary ol_shailesh" Please go through it and suggest me with any missing or addtional steps. Thanks & Regards, Shailesh M -------------------------------------------------------------------------------- ------------------------------- "Ce message contient des informations confidentielles protégées par le secret professionnel. Au cas où il ne vous serait pas destiné, nous vous remercions de bien vouloir nous en aviser immédiatement et de le supprimer. Les opinions exprimées au sein de ce message n'engagent que leur auteur et ne sont pas nécessairement celle de la société. MEDI TELECOM S.A. n'assume aucune obligation ni responsabilité s'agissant du contenu de ce courrier électronique, sauf si l'information est ultérieurement confirmée par écrit par un représentant habilité de la société. La transmission du courrier électronique ne peut être garantie comme sûre ou dénuée d'erreur dans la mesure où elle peut être altérée, perdue, détruite, retardée ou incomplète, ou contenir des virus. This e-mail and its attachments may contain CONFIDENTIAL information and are solely for the intended recipient. If you have received this e-mail in error, please immediately notify the sender and delete it from your system. The views expressed in this e-mail are solely those of the author and may not necessarily be those of, or supported by, the company. MEDI TELECOM SA. neither assumes obligations nor accepts liability for the content of this e-mail, unless that information is subsequently confirmed in writing by a duly authorised representative. E-mail transmission cannot be guaranteed to be secure or error-free as information could be corrupted, lost, destroyed, arrive late or incomplete, or contain VIRUSES. "

Hi, this is a problem similar to the one I just answered ... In your case: As the secondary needs to connect to the primary and the primary needs to be able to connect to the secondary, you of course need to provide them the respective port numbers. Therefore, the secondary needs to have a entry for "pri" in its /etc/services , so that it can know at which port number it can reach the primary. Just alike the primary needs an entry "sec" in its /etc/services file so that it can know the port number of the secondary. Needless to say that these numbers must match, i.e. the "sec" entry on primary machine needs to have the same port number as the "sec" entry on secondary machine. Same for the "pri" entries. [ The actual name of the service does not need to match, as this is just a local name, mainly for the convenience of humans - administrators :) - who have to read this stuff. Important is that the port number is correct. For more on this please see the other e-mail I wrote (Subject: Re: Client connection fails [823]). All the while, just for human comprehensibility the recommendation to keep same names for the same port numbers is not that bad an idea ... :) ] Regards, Martin -- Martin Fuerderer IBM Informix Development Munich Data Management Solutions forum.subscriber@iiug.org wrote on 18.04.2004 22:51:10: > > I think you must use the same service name in primary and secondary server > "pri or sec in the both servers" > > Best Regards > M. AFEILAL > > "Shailesh.Mo...." > <Shailesh.More@ril. > com> A > Envoyé par : ids@iiug.org > forum.subscriber@ii cc > ug.org > Objet > HDR setup problem [2839] > 17/04/2004 12:20 > > HI Informix gurus, > > I am facing a problem while setting up HDR replication between Informix > databases running on windows 2000. > > Below mentioned error I am getting in my log file:- > 17:37:45 DR: Primary to Primary > 17:37:45 DR: new type = primary, secondary server name = > ol_shaileshbackup > 17:37:45 DR: Cannot connect to secondary server > 17:37:45 DR: Turned off on primary server > > Following are my setps , which I followed to setup HDR:- > 1. Level 0 backup on primary server(ol_shailesh). > 2. Below mentioned are the entries made in the sqlhosts file of the primary > server. > ol_shailesh onsoctcp 10.8.87.36 pri > ol_shaileshbackup onsoctcp 10.8.87.80 sec> 3. In the services file of the primary server made following entry:- > pri 1526/tcp #ol_shailesh > 4. Run the command "onmode -d primary ol_shaileshbackup" > 5. Restored level 0 backup on the secondary server. Using command "ontape > -p" > 6. Below mentioned are the entry made in the sqlhosts file of secondary > server. > ol_shailesh onsoctcp 10.8.87.36 pri > ol_shaileshbackup onsoctcp 10.8.87.80 sec> 7. In the services file of secondary server made following entry:- > sec 1526/tcp #ol_shaileshbackup > 8. Run the command "onmode -d secondary ol_shailesh" > > Please go through it and suggest me with any missing or addtional steps. > > Thanks & > Regards, > Shailesh M