INFORMIX INSTANCES ON MORE THAN ONE MACHINES ... Please Help

Posted in 2000

shahid.mehmood@aku.edu — Fri, 3 Mar 2000 09:00:41 +0500 — source: Informix-list mailing list archive (1991-1998)

This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. ------_=_NextPart_001_01BF84C5.0AEF9D44 Content-Type: text/plain OS: SCO-OPEN SERVER 5.0 INFORMIX OnLine 7.20.UC2 Two instances are running on one box. Now I want to create another instance on different machine (same OS). Any help What should I do. Any user will connect to ONE INSTANCE at any given time. Its urgent. Please help Thanks in advance... Shahid Mehmood Software Designer II Information Systems Department The Aga Khan University Karachi Official:Y ------_=_NextPart_001_01BF84C5.0AEF9D44 Content-Type: text/html Content-Transfer-Encoding: quoted-printable <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN"> <HTML> <HEAD> <META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; = charset=3Dus-ascii"> <META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version = 5.5.2650.12"> <TITLE>INFORMIX INSTANCES ON MORE THAN ONE MACHINES ... Please = Help</TITLE> </HEAD> <BODY> OS:     = SCO-OPEN SERVER 5.0 INFORMIX OnLine = 7.20.UC2 Two instances are running on = one box. Now I want to create another instance on different machine = (same OS). Any help What should I do. Any user will connect to ONE = INSTANCE at any given time. Its urgent. Please help Thanks in advance... Shahid Mehmood Software Designer II Information Systems = Department The Aga Khan = University Karachi Official:Y </BODY> </HTML> ------_=_NextPart_001_01BF84C5.0AEF9D44--

↪ replying to shahid.mehmood@aku.edu

Edward Rosenthal — Fri, 03 Mar 2000 04:47:12 GMT — source: Informix-list mailing list archive (1991-1998)

not sure - but maybe you could use the enterprise gateway manager to gain access to the remote machine; thru the odbc driver that comes with it. shahid.mehmood@aku.edu wrote: > This message is in MIME format. Since your mail reader does not understand > this format, some or all of this message may not be legible. > > ------_=_NextPart_001_01BF84C5.0AEF9D44 > Content-Type: text/plain > > OS: SCO-OPEN SERVER 5.0 > INFORMIX OnLine 7.20.UC2 > > Two instances are running on one box. Now I want to create another instance > on different machine (same OS). Any help What should I do. Any user will > connect to ONE INSTANCE at any given time. > > Its urgent. Please help > > Thanks in advance... > > Shahid Mehmood > Software Designer II > Information Systems Department > The Aga Khan University > Karachi > Official:Y > > ------_=_NextPart_001_01BF84C5.0AEF9D44 > Content-Type: text/html > Content-Transfer-Encoding: quoted-printable > > <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN"> > <HTML> > <HEAD> > <META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; = > charset=3Dus-ascii"> > <META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version = > 5.5.2650.12"> > <TITLE>INFORMIX INSTANCES ON MORE THAN ONE MACHINES ... Please = > Help</TITLE> > </HEAD> > <BODY> > > OS:     = > SCO-OPEN SERVER 5.0 > INFORMIX OnLine = > 7.20.UC2 > > > Two instances are running on = > one box. Now I want to create another instance on different machine = > (same OS). Any help What should I do. Any user will connect to ONE = > INSTANCE at any given time. > > Its urgent. Please help > > > Thanks in advance... > > > Shahid Mehmood > Software Designer II > Information Systems = > Department > The Aga Khan = > University > Karachi > Official:Y > > > > </BODY> > </HTML> > ------_=_NextPart_001_01BF84C5.0AEF9D44--

↪ replying to shahid.mehmood@aku.edu

rane_vishal@my-deja.com — Fri, 03 Mar 2000 14:09:18 GMT — source: Informix-list mailing list archive (1991-1998)

if all the 3 instances r going to run on the same operating system then the following procedure should be followed. 1)set different directions in .profile for different instances set the following parameter seperately (unique) for every instance ONCONFIG, INFORMIXSERVER and DBSERVERNAME. 2)add one more line in $INFORMIXDIR/etc/sqlhosts file and a corresponding entry in /etc/services file . 4)after that u initialize disk space for new instance, while doing so set new path to ROOTPATH, unique no. to SERVERNUM, new MSGPATH and new MIRRORPATH if any. vishal In article <89ne8k$p7q$1@news.xmission.com>, shahid.mehmood@aku.edu wrote: > > This message is in MIME format. Since your mail reader does not understand > this format, some or all of this message may not be legible. > > ------_=_NextPart_001_01BF84C5.0AEF9D44 > Content-Type: text/plain > > OS: SCO-OPEN SERVER 5.0 > INFORMIX OnLine 7.20.UC2 > > Two instances are running on one box. Now I want to create another instance > on different machine (same OS). Any help What should I do. Any user will > connect to ONE INSTANCE at any given time. > > Its urgent. Please help > > Thanks in advance... > > Shahid Mehmood > Software Designer II > Information Systems Department > The Aga Khan University > Karachi > Official:Y > > ------_=_NextPart_001_01BF84C5.0AEF9D44 > Content-Type: text/html > Content-Transfer-Encoding: quoted-printable > > <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN"> > <HTML> > <HEAD> > <META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; = > charset=3Dus-ascii"> > <META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version = > 5.5.2650.12"> > <TITLE>INFORMIX INSTANCES ON MORE THAN ONE MACHINES ... Please = > Help</TITLE> > </HEAD> > <BODY> > > OS:     = > SCO-OPEN SERVER 5.0 > INFORMIX OnLine = > 7.20.UC2 > > > Two instances are running on = > one box. Now I want to create another instance on different machine = > (same OS). Any help What should I do. Any user will connect to ONE = > INSTANCE at any given time. > > Its urgent. Please help > > > Thanks in advance... > > > Shahid Mehmood > Software Designer II > Information Systems = > Department > The Aga Khan = > University > Karachi > Official:Y > > > > </BODY> > </HTML> > ------_=_NextPart_001_01BF84C5.0AEF9D44-- > Sent via Deja.com http://www.deja.com/ Before you buy.

↪ replying to shahid.mehmood@aku.edu

Art S. Kagel & Family — Wed, 29 Mar 2000 15:49:54 -0500 — source: Informix-list mailing list archive (1991-1998)

shahid.mehmood@aku.edu wrote: Please, try not to post MIME and HTML content. > OS: SCO-OPEN SERVER 5.0 > INFORMIX OnLine 7.20.UC2 > > Two instances are running on one box. Now I want to create another instance > on different machine (same OS). Any help What should I do. Any user will > connect to ONE INSTANCE at any given time. > > Its urgent. Please help No problem. Just make the entries for the new server in the SQLHOSTS files on the client machine (if the apps are running on the first server machine just make the entries there), include the new server in /etc/hosts and the server's service(s) in /etc/services on both server and client machines and set INFORMIXSERVER to the new server for those clients that need to see that server (or connect to that server explicitely in a DATABASE or CONNECT statement in your apps). -- Art S. Kagel & Family kagel@erols.com