Informix

 View Only

  • 1.  HDR Issue

    Posted Sat July 27, 2024 09:17 AM
      |   view attached

    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
    ------------------------------

    Attachment(s)

    docx
    INFORMIX HDR CONNECT ISSUE.docx   471 KB 1 version


  • 2.  RE: HDR Issue

    Posted Sun July 28, 2024 06:34 AM
    Edited by Boycho Velkov Sun July 28, 2024 06:39 AM

    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
    ------------------------------

    Original Message


  • 3.  RE: HDR Issue

    Posted Sun July 28, 2024 12:41 PM

    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
    ------------------------------

    Original Message


  • 4.  RE: HDR Issue

    IBM Champion
    Posted Sun July 28, 2024 07:00 AM

    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
    ------------------------------

    Original Message


  • 5.  RE: HDR Issue

    IBM Champion
    Posted Sun July 28, 2024 10:15 AM
    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


    Original Message


  • 6.  RE: HDR Issue

    Posted Mon July 29, 2024 06:23 PM
    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
    ------------------------------

    Original Message