Informix

nested-group-icon.png

DB2

Expand all | Collapse all

ODBC connection to group (of connection managers)

  • 1.  ODBC connection to group (of connection managers)

    Posted Mon October 19, 2020 07:11 AM
    Hi, I have somewhat limited experience with ODBC (or Windows, for that matter).

    We have two connection managers providing access to our cluster of Informix database servers. 
    From Unix and/or JDBC we are using sqlhosts to create groups of connection managers for this setup. 
    I am struggling with finding good information for this setup with ODBC (from Windows). Some of the suggested solutions involve first creating a normal connection to a informix host (or one of the connection managers), and then modify that with regedit. Is this really still required??

    Thanks in advance,

    ------------------------------
    Øyvind Gjerstad
    Developer/Architect
    PostNord AS
    ------------------------------


  • 2.  RE: ODBC connection to group (of connection managers)

    Posted Mon October 19, 2020 07:44 AM
      |   view attached
    Hi Gjerstad,

    I am attaching the relatively old document which describes step by step setup of connection manager and CSDK/ODBC connection information. Please let me know if need more information.
    Hope the document will help

    Thanks
    -Shesh


    ------------------------------
    Sheshnarayan Agrawal
    ------------------------------

    Attachment(s)



  • 3.  RE: ODBC connection to group (of connection managers)

    Posted Mon October 19, 2020 07:56 AM
    Thanks a lot for answering, but I could not find a description on how to configure connection to a group of connection managers in the attached document.
    We have the database servers and the connection managers running (on Linux) for many years, they work just fine, but for the ODBC connections from Windows we have only enabled one of the connection managers, not the group, so we are not utilizing multiple connection managers, and if this connection manager for some reason is down, the ODBC connection will not work currently.

    ------------------------------
    Øyvind Gjerstad
    Developer/Architect
    PostNord AS
    ------------------------------



  • 4.  RE: ODBC connection to group (of connection managers)

    Posted Mon October 19, 2020 08:09 AM
    Hi Gjerstad,

    The document I shared uses only "single connection manager with multiple servers". I haven't tried "multiple connection managers", however following the document (from page #9 onward), you should be able to modify/configure the same for "multiple connection managers".


    What you use on Linux/Unix as sqlhosts file, on Windows you have "Setnet32" utility to configure(sqlhosts file) the connection details for CSDK/ODBC(applications) on Windows.

    Thanks
    -Shesh

    ------------------------------
    Sheshnarayan Agrawal
    ------------------------------



  • 5.  RE: ODBC connection to group (of connection managers)

    Posted Mon October 19, 2020 08:45 AM
    You need to create a group in the windows registry that names the connection names for the two connection managers. You should also enter the group and the connection managers' details in the sqlhosts file on the machine.

    Art

    Art S. Kagel, President and Principal Consultant
    ASK Database Management


    Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference.  Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves.









  • 6.  RE: ODBC connection to group (of connection managers)

    Posted Tue October 20, 2020 09:46 AM

    @Art Kagel You've been answering this question for a LOOOOONG time. ;)

    https://members.iiug.org/forums/ids/index.cgi/noframes/read/30448​



    ------------------------------
    TOM GIRSCH
    ------------------------------



  • 7.  RE: ODBC connection to group (of connection managers)

    Posted Tue October 20, 2020 10:38 AM
    Yup, sure have.

    ------------------------------
    Art Kagel
    ------------------------------



  • 8.  RE: ODBC connection to group (of connection managers)

    Posted Tue October 20, 2020 09:42 AM
    In our environment, we worked around this issue via use of an F5. We created a virtual server on the F5 that forwards connections to the connection managers in a round-robin fashion. Then the ODBC setup is as simple as pointing the connection to the F5 virtual server, which does all the load balancing and failover for the CMs.

    As an added bonus, we were able to work around a problematic legacy app that connected to a decommissioned port by doing a port translation at the F5 level.

    ------------------------------
    TOM GIRSCH
    ------------------------------