Re: Table split into separate server and instance

"Simmons, Keith" <keith.simmons@bbslimited.co.uk> wrote in message news:<bck1mf$teh$1@terabinaries.xmission.com>... > At no point have you identified your O/S, Hardware or (most importantly) > your Informix Server Versions. From the message you are getting you appear > to be running on V 5.x. Have you installed I-NET or I-STAR? One of these are > needed to enable two V 5 engines to talk to each other (even on the same > box). > Once you have purchased, installed and configured this syntax will work. > Alternatively upgrade to V 7 or V 9 where such connectivity is integrated in > the engine and does not require purchase of a separate product. > > Keith Here is my system info :- Redhat 7.1(2.4.20-1) Informix Dynamic Server Version 9.30.UC1 I'm not sure whether I-NET was installed in the server. How to check whether I-NET is there ?

kh teoh wrote: >"Simmons, Keith" <keith.simmons@bbslimited.co.uk> wrote in message news:<bck1mf$teh$1@terabinaries.xmission.com>... > > >>At no point have you identified your O/S, Hardware or (most importantly) >>your Informix Server Versions. From the message you are getting you appear >>to be running on V 5.x. Have you installed I-NET or I-STAR? One of these are >>needed to enable two V 5 engines to talk to each other (even on the same >>box). >>Once you have purchased, installed and configured this syntax will work. >>Alternatively upgrade to V 7 or V 9 where such connectivity is integrated in >>the engine and does not require purchase of a separate product. >> >>Keith >> >> > >Here is my system info :- > >Redhat 7.1(2.4.20-1) >Informix Dynamic Server Version 9.30.UC1 > >I'm not sure whether I-NET was installed in the server. How to check >whether I-NET is there ? > > There is no I-NET for 9.30 - it is all built-in. Keith thought that you have an older version. You have to make sure both machines have entries for each other in hosts. You have to pick a service number and enter it into /etc/services. You have to setup sqlhosts on both machines for tcp connectivity. There was a buch on examples in the older Informix Online Administrator's Guide Vol 1 for 7.1 You may want to check if 9.3 docs also have the examples. However, you have to have a very good reason to split data like this. The penalty is a slow join as the data has to travel to the initiating server before it is joined. In 7.2 I also run into problems with outer joins between two servers. I have not tried that with 9.x yet. HTH Michael