Informix

Hello,

I already asked this on whatsapp channel

Does anyone use drda connection to group of connection managers? here is my connection string:
<add name="name2" connectionString="Server=IPADDRESS:PORT;User ID=user;Password=password;Database=mydb;Persist Security Info=True;" providerName="Base.InformixDatabase" />
and it can connect directly to drda listener. But what when i have sqlhosts like this:
####
drda_grp     group    -            -      c=1,e=cm3_drd_sla
cm2_drd_sla  drsoctcp 10.10.10.12  9089   g=drda_grp
cm3_drd_sla  drsoctcp 10.10.10.13  9089   g=drda_grp
####
and cm2/3 are listening on 9089 for drda connections
How can I connect to group since IBM Data Server Driver does not know about sqlhosts file?
I'm aware of this
https://ibm.co/47RpGp4
but still - what to put in connection string

Hrvoje

Finally working with support (thanks Joey) we managed to configure cluster.

I have 2 IDS servers - in HDR pair. Next, "in fornt" there are 2 Connection Managers - with different priority, of course.

Only problem not resolved is that you cant configure just drda cluster (i.e. listening just for drda connections) - since IDS is not aware of that (onstat -g cmsm shows nothing). So you must have sqli listener even if you are not using it.

Next, on client (windows, .NET app) I installed IBM Data Server Driver and app is "using IBM.Data.DB2;"

Trick is in configuration in db2dsdriver.cfg file (somewhere under C:\ProgramData\IBM\DB2\ something \cfg\). In my case file looks like this:

This line is "pointing" to first CM (not database server):

<database host="172.16.0.62" name="test" port="14101">

is almost the same as connection string:

connStr = "Server=172.16.0.62:14101;Database=test;UID=informix;PWD=password;";

and in "acr" (stands for "automatic client reroute") there are other CMs - in my case just one:

<server name="172.16.0.64" hostname="172.16.0.64" port="14101"/> 

Anf it is working :)

Hrvoje