Informix

nested-group-icon.png

DB2

Expand all | Collapse all

ER Connection issue

  • 1.  ER Connection issue

    Posted Tue August 25, 2020 09:57 AM

    Hi All,

    I am trying to link an Informix 14.10.FC3 instance running on a RHEL7 server to an Informix 12.10.FC4 instance running on a Solaris 10 server.  (I previously had both servers connected, but using the same Informix 12.10)

    IBM Informix Dynamic Server Version 14.10.FC3 -- On-Line -- Up 03:23:42 -- 3946412 Kbytes
    IBM Informix Dynamic Server Version 12.10.FC4 -- On-Line -- Up 01:49:52 -- 7032832 Kbytes

    I can connect in both directions using DBACCESS, so the servers can talk to each other.

    I am attempting to define a new server connection, which will be the original for both systems:

    cdr define server --connect=i14_srepl_tcp --init g_upg_srepl --nonroot --sync=g_upg_scli


    On the REHL7 side (i14_srepl_tcp & g_upg_srepl), I amgetting:

    14:05:18 CDR connection to server lost, id 12, name <g_upg_scli>
    Reason: ASF connect error (-27002)
    14:05:18 CDR GC: operation sync connect failed (error 5).
    14:05:18 CDR GC: synchronization failed (sync abort, shutting down CDR)


    On the Solaris side (g_upg_scli), the error is just:
    14:05:18 (62) connection rejected - no calls allowed for cdraccept

    if it helps, this is the relevant section of the sqlhosts file on each system:
    RHEL7:
    ----------
    g_upg_srepl group - - i=42
    i14_srepl_tcp onsoctcp rh7data 5142 g=g_upg_srepl

    g_upg_scli group - - i=12
    sylvestercfp_tcp onsoctcp clientdata 5196 g=g_upg_scli


    Solaris:
    ----------
    g_upg_scli group - - i=12
    sylvestercfp_tcp onsoctcp clientdata 5196 g=g_upg_scli

    g_upg_srepl group - - i=42
    i14_srepl_tcp onsoctcp rh7data 5142 g=g_upg_srepl


    Thanks Much,
    Michael Hoffman 



    ------------------------------
    Michael Hoffman
    ------------------------------


  • 2.  RE: ER Connection issue

    Posted Tue August 25, 2020 10:02 AM

    Can you bi-directional connect without a password  from dbaccess using the group/informix servers name ?

     

    But 27002 is engine is Queisicent – needs to be online

     

    Cheers

    Paul

     






  • 3.  RE: ER Connection issue

    Posted Tue August 25, 2020 10:30 AM

    Hi Paul,
    Yes, I can connect bi-directionally via dbaccess without a password.

    The Quiescent error message is a red herring.  Both instances are Online.  (That's why I included the onstat - messages  :-) )

    Thanks,
    Mike



    ------------------------------
    Michael Hoffman
    ------------------------------



  • 4.  RE: ER Connection issue

    Posted Tue August 25, 2020 10:48 AM

    Is the 'master' defined ?

     

    Cheers

    Paul

     






  • 5.  RE: ER Connection issue

    Posted Tue August 25, 2020 10:32 AM

    We have a WINNER!!!!!   Thanks Jacques!!!

    Jacques had issues replying to the thread, so he replied privately.  I'm dropping it here so others can learn from my error.
    ---------------
    Message From: Jacques Renaut

    For some reason it doesn't seem like I can respond to your post, so I'm going to try and reply privately.

    I think the issue is simply that you haven't done the cdr define server 1st on server that you are trying to use as the sync server in the "cdr define server" command you listed.  I believe if you do the define server on that machine 1st, then the command you are trying to run will then work.  So if you are using the sync in your cdr define server command, that server needs to already have been added.


    ------------------------------
    Jacques Renaut
    ------------------------------




    ------------------------------
    Michael Hoffman
    ------------------------------



  • 6.  RE: ER Connection issue

    Posted Tue August 25, 2020 12:03 PM

    I just attempted something similar to what I think you are doing.  I think the issue is you are trying to define the server first on server i14_srepl_tcp/g_upg_srepl, but you are telling it the sync server is going to be sylvestercfp_tcp/g_upg_scli, but you haven't done the cdr define server on sylvestercfp_tcp/g_upg_scli.

    from my test doing something similar (without the --nonroot)

    cdr define server --init g_er2 --sync=g_er1

    from MSGPATH of g_er1:
    09:06:02 (93) connection rejected - no calls allowed for cdraccept

    from MSGPATH of g_er2:
    09:05:59 DDR Log Snooping - Snooping started in log 195
    09:06:01 CDR: WARNING: Server is configured with /tmp as the ATS and RIS directory.
    If /tmp is configured as the swap space of this machine then it can
    affect the machine's performance if ER generated a large amount of
    files in this directory.
    09:06:02 CDR connection to server lost, id 101, name <g_er1>
    Reason: ASF connect error (-27002)
    09:06:02 CDR GC: operation sync connect failed (error 5).
    09:06:02 CDR GC: synchronization failed (sync abort, shutting down CDR)
    09:06:03 CDR NIF Shutdown: connections all shutdown.
    09:06:03 CDR The NIF sub-component has shut down.
    09:06:04 DDR Log Snooping - Shutdown
    09:06:04 CDR shutdown complete

    So in my case, I would need to do my cdr define server 1st on g_er1.



    ------------------------------
    Jacques Renaut
    ------------------------------