Re: Table split into separate server and instance

Michael Krzepkowski <NOmichaelkSPAM@sqlcanada.com> wrote in message > > > 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 > This time I didn't go too far. Just experimenting the SQL statement in dbaccess on one server only. db4 and db6 are 2 databases from single instance TEST which is reside in the same server. I run the command below in the dbserver itself(not across network). select a.branch_code, a.user_id, b.branch_code, b.user_id from db4@TEST:code_pwdaccess a, db6@TEST:code_pwdaccess b# ^ # 908: Attempt to connect to database server (TEST, conerr=-25555, oserr=0) fail ed. # where a.user_id = b.user_id I've no idea what I did wrong. In my sqlhosts I've this :- TEST onipcshm 10.185.66.186 abc TEST186 onsoctcp 10.185.66.186 8877 Of coz with the following SQL I've no problem(I set enviroment variable INFORMIXSERVER=TEST). select a.branch_code, a.user_id, b.branch_code, b.user_id from code_pwdaccess a, code_pwdaccess b where a.user_id = b.user_id Actually I agree with Michael about disadvantage of doing this. The idea came from my boss :(, therefore I need to find out whether his idea is feasible or not :<.