Using Informix ODBC with connection manager
Hi Guys, We are going to use Informix connection manager to manage connectivity among our database instances (Primary, HDR and RSS) as per following article but I am not sure what I will be using as ODBC settings as host name, service etc. because, when connection manager manages connections among multiple servers, host name will not be unique every time. Any cluses or inputs in this matter is highly appreciated. Thanks and regards - Sanjeewa http://pic.dhe.ibm.com/infocenter/idshelp/v117/index.jsp?topic=%2Fcom.ibm.admin. doc%2Fids_admin_1174.htm ################################################################################ ##### This e-mail message has been scanned for Viruses and Content and cleared by MailMarshal ################################################################################ ##### Please consider the environment before printing this e-mail. Any personal or sensitive information contained in this e-mail and attachments must be handled in accordance with the Victorian Information Privacy Act 2000, the Health Records Act 2001 or the Privacy Act 1988 (Commonwealth), as applicable. This e-mail, including all attachments, is confidential. If you are not the intended recipient, you must not disclose, distribute, copy or use the information contained in this e-mail or attachments. Any confidentiality or privilege is not waived or lost because this e-mail has been sent to you in error. If you have received it in error, please let us know by reply e-mail, delete it from your system and destroy any copies.
Hello. As soon as you implement your CM, it will be a "network gateway" for your production cluster (and maybe redirect your connections to any cluster node, according to your CM defined policy). So, your ODBC connection will be changed from your database, to your CM hostname/port. You must change your clients sqlhosts (or registry information), to go through your CM, instead of just connecting directly to your Informix server. Hope it helps. 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: Sanjeewa.Gunasekara@whittlesea.vic.gov.au > Subject: Using Informix ODBC with connection manager [32013] > Date: Sun, 24 Nov 2013 18:54:35 -0500 > > Hi Guys, > > We are going to use Informix connection manager to manage connectivity among > our database instances (Primary, HDR and RSS) as per following article but I > am not sure what I will be using as ODBC settings as host name, service etc. > because, when connection manager manages connections among multiple servers, > host name will not be unique every time. > Any cluses or inputs in this matter is highly appreciated. > > Thanks and regards - Sanjeewa > > > http://pic.dhe.ibm.com/infocenter/idshelp/v117/index.jsp?topic=%2Fcom.ibm.admin. doc%2Fids_admin_1174.htm > > > ################################################################################ ##### > This e-mail message has been scanned for Viruses and Content and cleared > by MailMarshal > > ################################################################################ ##### > > Please consider the environment before printing this e-mail. > > Any personal or sensitive information contained in this e-mail and attachments > must be > handled in accordance with the Victorian Information Privacy Act 2000, the > Health Records Act 2001 or the Privacy Act > 1988 (Commonwealth), as applicable. > > This e-mail, including all attachments, is confidential. If you are not the > intended recipient, you must not disclose, distribute, copy or use > the information contained in this e-mail or attachments. > Any confidentiality or privilege is not waived or lost because this e-mail has > been sent to you in error. > If you have received it in error, please let us know by reply e-mail, delete > it from your system and destroy any copies. > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. >
Hi Alexandre, Thanks a lot for your reply post. Later I found in another IBM redbook that ODBC connections need to use connection manager server's host as host name as well as the SLA name for Informix server name. Could you list an example of using CM host's ports as well ? Ex: sqlhosts file and connecion manager config file lines. Regards - Sanjeewa