Rebuid sysmaster database and effects in a HDR/RSS
The original poster asked whether rebuilding sysmaster on a production instance with $INFORMIXDIR/etc/buildsmi would cause problems with attached HDR/RSS secondaries, and whether a rootdbs restore would be the only recovery option. That question was never answered. The thread was taken over by a separate issue: setting up HDR on Windows Server 2012 R2, where trusted connections via hosts.equiv weren't working and dbaccess kept prompting for credentials. Links to the IBM docs on trusted-host files were offered; the poster later reported HDR working but never said what fixed it, then moved on to asking about Connection Manager failover setup. No resolution recorded for either question.
Auto-generated by DrWatson from the posts below — may be imperfect; read the full thread.
Hello I need rebuild sysmaster database in our production instance. I think running the "$INFORMIXDIR/etc/buildsmi" script will not cause problems with our HDR/RSS instances, but I'm not sure. Anyone know if there is any kind of incompatibility (rebuilding sysmaster) with an HDR and RSS environment? In case of problems, the only option is a rootdbs Restore?
Hello MITRA SADAI, I need your help, im under high level pressure. I have seen your post but i need information on other. I hope you implemented HDR, so now we are implementing HDR on Windows server 2012 R2 environment. Could you please share any document related to HDR on windows. I not able to establish a trusted connection. through DBACCESS while connecting to other server it prompts username and password. how to establish trusted connection need step by step process. Please help
Hello MUKESH, Unfortunately, we have implemented the HDR environment on AIX / Power7 machines. We do not work with IDS in Windows environments. But on the subject you comment I can tell you some links that I think will help you: https://www.ibm.com/support/knowledgecenter/en/SSGU8G_12.1.0/com.ibm.admin.doc/i ds_admin_1407.htm http://informix-technology.blogspot.com.es/2009/04/informix-authentication-and-c onnections.html "On Windows, the trusted-host file is in the \\\\%WINDIR%\\\\system32\\\\drivers\\\\etc directory." Best regards Mitra
Actually I created the hosts.equiv file on both servers contains the hostname and user of opposite server. But the connection is not establishing. I unable to connect through DBACCESS to other server. It is promoting for username and password. So i think trusted connection is not established.
The informix log should show an error message if HDR is set up but the servers can't talk to each other. Do you see anything like that? -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of MUKESH TANUKU Sent: Wednesday, June 28, 2017 11:58 AM To: ids@iiug.org Subject: Re: Rebuid sysmaster database and effects in a HDR [39472] Actually I created the hosts.equiv file on both servers contains the hostname and user of opposite server. But the connection is not establishing. I unable to connect through DBACCESS to other server. It is promoting for username and password. So i think trusted connection is not established. **************************************************************************** *** Forum Note: Use "Reply" to post a response in the discussion forum.
HDR set is successfully done. Thanks for your support. Now I need to configure Connection Manager for automatic failover process. I gone through all IBM websites. but tough to understand. Could any one help me on this. only between two servers. Primary and secondary
Can you share what the fix was for the HDR problem? For Connection Manager, Tom Beebe did a webcast just yesterday on how to set this up. If you missed it, a replay of it will be posted soon - look out for a notice on that. Mike -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of MUKESH TANUKU Sent: Friday, June 30, 2017 6:33 AM To: ids@iiug.org Subject: Re: RE: Rebuid sysmaster database and effects .... [39483] HDR set is successfully done. Thanks for your support. Now I need to configure Connection Manager for automatic failover process. I gone through all IBM websites. but tough to understand. Could any one help me on this. only between two servers. Primary and secondary **************************************************************************** *** Forum Note: Use "Reply" to post a response in the discussion forum.