Same server name on the same host
Joe asked whether two IDS 9.4 instances on one host can share a server name using different sqlhosts files. Art Kagel said yes via INFORMIXSQLHOSTS per user if nobody needs to see both, and SERVERNUM must be unique. Fernando Nunes and Alexandre Marini said it is possible but confusing and not recommended. Superboer added it needs TCP connections and different ports.
Auto-generated by Claude from the posts below — may be imperfect; read the full thread.
Version : ids 9.4 Can I set up 2 instance which has the same server name ? What if I set 2 different SQLHOSTS files ?
Yes you can as long as no user needs to be able to "see" both instances and they do not have to "see" each other you can do it with each user setting a different sqlhosts file in thier INFORMIXSQLHOSTS environment variable (full path). The SERVERNUM however, has to be unique on each machine. 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 Tue, Nov 13, 2012 at 5:58 AM, joe <joeclhua@gmail.com> wrote: > Version : ids 9.4 > > Can I set up 2 instance which has the same server name ? > > What if I set 2 different SQLHOSTS files ? > _______________________________________________ > Informix-list mailing list > Informix-list@iiug.org > http://www.iiug.org/mailman/listinfo/informix-list >
You can, using different INFORMIXSQLHOSTS, but that's the first step for confusion :) On Tue, Nov 13, 2012 at 10:58 AM, joe <joeclhua@gmail.com> wrote: > Version : ids 9.4 > > Can I set up 2 instance which has the same server name ? > > What if I set 2 different SQLHOSTS files ? > _______________________________________________ > Informix-list mailing list > Informix-list@iiug.org > http://www.iiug.org/mailman/listinfo/informix-list > -- Fernando Nunes Portugal http://informix-technology.blogspot.com My email works... but I don't check it frequently...
Hello. It is called Multiple Residency (more that 1 Informix engine, in the same physical machine). You can use the same server name (if you mean INFORMIXSERVER var), but it is not recommended at all (to avoid any possible mistakes). You should use different INFORMIXSERVERs, SQLHOSTs and so on....) There is a good material link (11.50) but I think it will fit your needs. http://publib.boulder.ibm.com/infocenter/idshelp/v115/topic/com.ibm.expr.doc/ids_in_045x.htm It´s based on linux, but there is also one for Windows ok? Hope it helps. Regards. Alexandre Marini IBM Informix Certified Professional v10 / v11.50 / v11.70 IBM Information Management Informix Technical Professional IBM Infosphere DataStage Technical Professional Informix Senior DBA - Orizon Brasil BRIUG website administrator Informix independent consultant > Date: Tue, 13 Nov 2012 02:58:41 -0800 > Subject: Same server name on the same host > From: joeclhua@gmail.com > To: informix-list@iiug.org > > Version : ids 9.4 > > Can I set up 2 instance which has the same server name ? > > What if I set 2 different SQLHOSTS files ? > _______________________________________________ > Informix-list mailing list > Informix-list@iiug.org > http://www.iiug.org/mailman/listinfo/informix-list
Am Dienstag, 13. November 2012 11:58:41 UTC+1 schrieb joe: > Version : ids 9.4 > > Can I set up 2 instance which has the same server name ? > > What if I set 2 different SQLHOSTS files ? You can as long as INFORMIXSERVER is a tcp connection and of course use INFORMIXSQLHOSTS to point at different sqlhost files and use different ports Superboer.
Related threads
- the longer you surf, the MORE $$$ you earn !!
- Store procedure
- emulation for Vt100
- extent size questions again ...