Informix connection manager

G'day All, Can someone give me a clue on deriving values to be used in ODBC within the context of following connection manager example ? If so that would be a great help in a situation where training will not be avaialble to cover up such topics. I am going through IBM Informix documentation on their web site http://pic.dhe.ibm.com/infocenter/idshelp/v117/index.jsp?topic=%2Fcom.ibm.admin. doc%2Fids_admin_1176.htm as some study material for a project that we are trying to do and it is very hard for me to understand how a connection manager group settings are used in following application/ODBC parameters. Informix Server : ifx_cm Hostname : ????????????? Service/Port : ????????????? rest of the values will be common for both servers (database name etc) Is there a common hostname that can be used or it has to be either cm1_machine or cm2_machine ? When cm1_machine is used by a client and if cm1_machine goes offline, how does client connect to cm2_machine automatically ? Thanks and Regards - Sanjeewa Context: (using multiple instances of connection manager to avoid single point of failure) dbservername nettype hostname servicename options ifx_pri onsoctcp p_machine ifxsrv0pri # ifx_cm group ifx_cm group - - c=1 ifx_cm1 onsoctcp cm1_machine cm1_port1 g=ifx_cm ifx_cm2 onsoctcp cm2_machine cm2_port2 g=ifx_cm

Each entry in the connection manager gets tied to an SLA. Each SLA gets assigned to a different port. Then, the ODBC connection would be setup to point to a specific port (and hence, an SLA). Assuming you setup the connection manager on each of the servers, in a nutshell you need to setup both connection manager connections on the clients, and then setup a group to group them together. Finally, your application points to the group. I had a similar question earlier this year (start of thread here: http://www.iiug.org/forums/ids/index.cgi/read/30447), and some good links that were provided to me were: http://informix-technology.blogspot.com.br/2013/08/sqlhosts-options-opcoes-do-sq lhosts.html http://www-01.ibm.com/support/docview.wss?uid=swg21447622 -Justin -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of SANJEEWA GUNASEKARA Sent: Tuesday, December 10, 2013 8:12 PM To: ids@iiug.org Subject: Informix connection manager [32118] G'day All, Can someone give me a clue on deriving values to be used in ODBC within the context of following connection manager example ? If so that would be a great help in a situation where training will not be avaialble to cover up such topics. I am going through IBM Informix documentation on their web site http://pic.dhe.ibm.com/infocenter/idshelp/v117/index.jsp?topic=%2Fcom.ibm.admin. doc%2Fids_admin_1176.htm as some study material for a project that we are trying to do and it is very hard for me to understand how a connection manager group settings are used in following application/ODBC parameters. Informix Server : ifx_cm Hostname : ????????????? Service/Port : ????????????? rest of the values will be common for both servers (database name etc) Is there a common hostname that can be used or it has to be either cm1_machine or cm2_machine ? When cm1_machine is used by a client and if cm1_machine goes offline, how does client connect to cm2_machine automatically ? Thanks and Regards - Sanjeewa Context: (using multiple instances of connection manager to avoid single point of failure) dbservername nettype hostname servicename options ifx_pri onsoctcp p_machine ifxsrv0pri # ifx_cm group ifx_cm group - - c=1 ifx_cm1 onsoctcp cm1_machine cm1_port1 g=ifx_cm ifx_cm2 onsoctcp cm2_machine cm2_port2 g=ifx_cm ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.

hi Justin, Many thanks for your reply post and links containing answers to my question. I am going through them now at the moment and find really useful. (Also, your previous post and answers to it with IBM support doc. If I have any doubts will post it back.. Regards - Sanjeewa