HDR Issue

Hello All, I'm doing Informix HDR setup in personal laptop with using vmware. VM - Oracle Virtual Box Linux - RHEL 7.9 IDS - 14.10 I create two virtual machines and accessing those machine using putty in windows. Looks I am missing something in Informix configuration side, As I checked everything from Linux side connectivity e.g. Telnet, ssh etc. Kindly help me to find the root cause to HDR Connection issue. attached the word file for the reference. Thanks Amit Patel ------------------------------ AMIT PATEL ------------------------------

Hi Amit, May be your problem is with "hosts.equiv" file. Try to create "/etc/hosts.equiv" file if it's not exists and add this information: On host ifxdb1(ifxdb1.dev.node.com) ifxdb2 informix ifxdb2.dev.node.com informix On host ifxdb2(ifxdb2.dev.node.com) ifxdb1 informix ifxdb1.dev.node.com informix You can also change /etc/hosts file on both hosts: 192.168.31.199 ifxdb1.dev.node.com ifxdb1 192.168.31.200 ifxdb2.dev.node.com ifxdb2 Regards, ------------------------------ Boycho Velkov ------------------------------

Remove the s=6 from the sqlhosts files, until you have verified the connectivity. Then, from your secondary server, see if you can connect to the primary server with that connection, e.g.: (On ifxdb2), run: dbaccess sysmaster@ol_ganga_prim Check any error messages and check the Informix log on the primary to see if there is any message there about a failed connection attempt. Also, what do you have in your onconfig files for REMOTE_SERVER_CFG and S6_USE_REMOTE_SERVER_CFG ? ------------------------------ Mike Walker xDB Systems, Inc www.xdbsystems.com ------------------------------

Hi Amit First try to have both instances working on each server independently and try to connect both ways. Try to connect from server 1 to server 2 and vice versa. It might be the equivalence : /etc/hosts.equiv or .rhosts Khaled Bentebal de mon portable

Hello Boycho , Thanks for your reply. Changing hostname with IP Address in SQLHOST file worked. Looks from Unix level hostname not taking the IP Addressing. Thanks again. Regards Amit Patel ------------------------------ AMIT PATEL ------------------------------

It sounds like you're setting up an Informix HDR (High-Availability Data Replication) environment on your personal laptop using Oracle VirtualBox and RHEL 7.9. Since you've checked the Linux side connectivity and everything seems fine (e.g., Telnet, SSH), the issue might be related to the Informix configuration. Here are a few things you might want to check: Informix Configuration Files: ONCONFIG: Ensure that the DRDAUTO parameter is set correctly, and the HDR configuration parameters such as DRLOSTFOUND, DRINTERVAL, and DRTIMEOUT are properly configured. sqlhosts: Make sure the sqlhosts file has the correct entries for both the primary and secondary servers, and that the hostnames/IPs are reachable from both machines. Networking: Firewall: Check if the firewall settings on your VM or host machine are blocking the required ports for Informix. You can use iptables or firewalld commands to check and update the firewall settings. Network Interfaces: Ensure that the network interfaces are correctly configured and the VMs can communicate with each other. Hostname Resolution: Make sure that both the primary and secondary servers can resolve each other's hostnames. You can test this with the ping command. If necessary, update the /etc/hosts file with the appropriate IP addresses and hostnames. Informix Services: Verify that the Informix services (oninit processes) are running on both servers. You can use the onstat - command to check the status of the servers. HDR Logs: Check the Informix logs for any error messages related to HDR. The logs can provide more detailed information about what might be going wrong. You can find the logs in the online.log file located in the $INFORMIXDIR directory. Matching Configuration: Ensure that the ROOTPATH, DBSERVERNAME, DBSERVERALIASES, and other critical parameters are correctly set and match between the primary and secondary servers as required. Network Latency: Although unlikely in a local VM setup, network latency or instability can sometimes cause issues. Check the stability of the network connections between the VMs. If you've already checked these aspects and are still facing issues, please provide more specific details or error messages from the logs. This information will help in diagnosing the problem more accurately. You can also refer to the Informix documentation for detailed steps on HDR setup and configuration. If the issue persists, consider reaching out to the IBM support team for more specialized assistance. Good luck with your setup! ------------------------------ Muhammad Sajjad ------------------------------