IDS Forum

RE: windows odbc connection to connection mana....

Posted By: Justin Killen
Date: Thursday, 8 August 2013, at 1:39 p.m.

In Response To: RE: windows odbc connection to connection mana.... (Alexandre Marini)

Alexandre,

I have two problems with that article:
1) It is explaining how to setup a sqlhosts file, which windows doesn't use (Art provided a link earlier in the tread for an IBM doc that explains how to set it up on a windows system)
2) It doesn't specify a minimum CSDK version

-Justin

-----Original Message-----
From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of Alexandre Marini
Sent: Thursday, August 08, 2013 10:24 AM
To: ids@iiug.org
Subject: RE: windows odbc connection to connection mana.... [31091]

Hello.
Supposing you have a group of servers, it should randomly connect to all of
them.
For more information, our friend Fernando Nunes has made a complete article
about sqlhosts features, check it out:

http://informix-technology.blogspot.com.br/2013/08/sqlhosts-options-opcoes-do-sqlhosts.html

Regards.

Alexandre Marini
IBM Informix Certified Professional v10 / v11.50 / v11.70 / v12.10

IBM Information Management Informix Technical Professional

IBM Infosphere DataStage Technical Professional
Informix Senior DBA - Orizon Brasil
BRIUG website administrator
Informix independent consultant

> To: ids@iiug.org
> From: jkillen@allamericanasphalt.com
> Subject: RE: windows odbc connection to connection mana.... [31089]
> Date: Thu, 8 Aug 2013 13:10:54 -0400
>
> Does the c=1 option work for the windows CSDK 3.50.TC5? I have the option
> listed in the group registry key, but always seems to go back to the same
> server (the first one alphabetically).
>
> -Justin
> -----Original Message-----
> From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of Art
> Kagel
> Sent: Thursday, June 06, 2013 4:50 PM
> To: ids@iiug.org
> Subject: Re: windows odbc connection to connection mana.... [30450]
>
> You are almost right, c=1 means that instead of every client connecting in
> the specified order starting with the first listed connection name each
> client selects one of the connection names at random then cycles through
> the list if the first one it tries doesn't respond. Not exactly round
> robin, but it does do some load distribution if not balancing.
>
> Art
>
> Art S. Kagel
> Advanced DataTools (www.advancedatatools.com)
> Blog: http://informix-myview.blogspot.com/
>
> Disclaimer: Please keep in mind that my own opinions are my own opinions
> and do not reflect on my employer, Advanced DataTools, 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.
>
> On Thu, Jun 6, 2013 at 6:47 PM, Justin Killen <
> jkillen@allamericanasphalt.com> wrote:
>
> > Art,
> >
> > Thanks - that works great! I think when we deploy the connection setup to
> > the
> > client machines we'll be using registry files anyway, so requiring a few
> > extra
> > keys is no big deal.
> >
> > As for the round-robin, I was under the impression that the option "c=1"
> > setup
> > servers for round-robin distribution, but perhaps I'm mistaken.
Round-robin
> > connections to the CM's isn't a requirement for us, so it's not something
> > I'm
> > going to worry about.
> >
> > -Justin
> >
> > -----Original Message-----
> > From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of Art
> > Kagel
> > Sent: Thursday, June 06, 2013 2:50 PM
> > To: ids@iiug.org
> > Subject: Re: windows odbc connection to connection mana.... [30448]
> >
> > Justin:
> >
> > See this link for how to configure windows apps to use sqlhsots "groups":
> >
> > http://www-01.ibm.com/support/docview.wss?uid=swg21447622
> >
> > You have to manually edit the registry to enter the definition of the
group
> > since there is no sqlhosts file on the windows side.
> >
> > Also, AFAIK, using groups does not round robin through the group members,
> > it just sequentially tries each group member, in the order they are
listed,
> > until one of them responds. Groups are for failover not load balancing
> > (hence the need for Connection Manager). You can make it kind of
> > round-robin/load-balancing by using the environment variables
> > INFORMIX_CONTIME and INFORMIX_CONRETRY to configure how long the client
> > will wait for a response from SOME group member before returning an error
> > and how many retries the client will make within that time. Indirectly
> > that will configure the time the client waits for each member before
trying
> > to connect to the next member of the group.
> >
> > Art
> >
> > Art S. Kagel
> > Advanced DataTools (www.advancedatatools.com)
> > Blog: http://informix-myview.blogspot.com/
> >
> > Disclaimer: Please keep in mind that my own opinions are my own opinions
> > and do not reflect on my employer, Advanced DataTools, 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.
> >
> > On Thu, Jun 6, 2013 at 5:22 PM, Justin Killen <
> > jkillen@allamericanasphalt.com> wrote:
> >
> > > I have 3 connection manager (Linux) instances whose SLA's are in a group
> > in
> > > sqlhosts (group option c=1). When I run dbaccess on any of those
> > machines,
> > > the
> > > SLA group is listed as an option, and I can connect to the group (it
will
> > > round-robin my connection to one of the connection managers).
> > > Now that it is working on the servers themselves, I'd like to get it to
> > > work
> > > on my windows PC. I've added the SLA for each server as well as the SLA
> > > group
> > > into the system via Setnet32. When creating an ODBC connection, I'm
using
> > > the
> > > following information:
> > >
> > > Server Name: sla_cm_grp
> > > Host Name: -
> > > Service: -
> > > Protocol: group
> > > Options: c=1
> > >
> > > When I try to test the connection, I get the error:
> > > "[Informix][Informix ODBC Driver][Informix]Server sla_cm_grp is not
> > listed
> > > as
> > > a dbserver name in sqlhosts"
> > > If I use any of the connection managers directly I can connect just
> > fine, I
> > > just can't get it to connect to the group. Is this option supported by
> > the
> > > ODBC framework?
> > >
> > > I'm using CSDK version 3.50 TC8 on the windows machine. Server is
running
> > > on
> > > Linux, Informix 12.1
> > >
> > > -Justin
> > >
> > >
> > >
> > >
> >
> >
> >
>
>
*******************************************************************************
> > > Forum Note: Use "Reply" to post a response in the discussion forum.
> > >
> > >
> >
> > --089e013d1a4a91d12904de834cd0
> >
> >
> >
> >
>
>
*******************************************************************************
> > Forum Note: Use "Reply" to post a response in the discussion forum.
> >
> >
> >
> >
>
>
*******************************************************************************
> > Forum Note: Use "Reply" to post a response in the discussion forum.
> >
> >
>
> --089e01493c1ea0be0604de84f9f1
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>

*******************************************************************************
Forum Note: Use "Reply" to post a response in the discussion forum.

Messages In This Thread

• windows odbc connection to connection manager grou
  Justin Killen -- Thursday, 6 June 2013, at 5:22 p.m.
  • Re: windows odbc connection to connection manager
    Art Kagel -- Thursday, 6 June 2013, at 5:50 p.m.
    • RE: windows odbc connection to connection mana....
      Justin Killen -- Thursday, 6 June 2013, at 6:47 p.m.
      • Re: windows odbc connection to connection mana....
        Art Kagel -- Thursday, 6 June 2013, at 7:50 p.m.
        • RE: windows odbc connection to connection mana....
          Justin Killen -- Thursday, 8 August 2013, at 1:10 p.m.
          • Re: windows odbc connection to connection mana....
            Art Kagel -- Thursday, 8 August 2013, at 1:18 p.m.
            • RE: windows odbc connection to connection mana....
              Justin Killen -- Thursday, 8 August 2013, at 1:34 p.m.
              • RE: windows odbc connection to connection mana....
                Paul Watson -- Thursday, 8 August 2013, at 1:39 p.m.
                • RE: windows odbc connection to connection mana....
                  Justin Killen -- Thursday, 8 August 2013, at 3:16 p.m.
          • RE: windows odbc connection to connection mana....
            Alexandre Marini -- Thursday, 8 August 2013, at 1:23 p.m.
            • RE: windows odbc connection to connection mana....
              Paul Watson -- Thursday, 8 August 2013, at 1:27 p.m.
            • RE: windows odbc connection to connection mana....
              Justin Killen -- Thursday, 8 August 2013, at 1:39 p.m.
              • RE: windows odbc connection to connection mana....
                John Miller iii -- Friday, 9 August 2013, at 10:49 a.m.

IDS Forum is maintained by Administrator with WebBBS 5.12.