[foxboro] AW: Informix Star: access tables from another AW : Summary

Thanks Steve! Your hint was very helpful.

Steps for using Informix Star or how to access a remote Informix
Database:

0) Add the names of the other AWs to your /etc/inet/hosts file

1) Add two entries into the /etc/services

# Informix client-server support
sqlexec         1525/tcp
sqlturbo        1526/tcp
star            1541/tcp        # this service should already exists


2) Modify the /opt/informix/etc/sqlhosts=20
and add the names of the remote AWs
Please be careful and use the ip-address of your second ethernet network
card.

AW51C# more sqlhosts
#SQLHOST       NET             MACHINE        SERVICE     original
Foxboro
#servername    nettype         hostname       servicename like the
documentation
<Ladderbug>    olsoctcp        <hostname>     star


3) Restart the Informix-Star daemon
# /opt/informix/lib/sqlexecd


4) Run a sql statement using isql=20

select id from historianName@servername:tablename


Andreas Weiss

BP Koeln





 
 
_______________________________________________________________________
This mailing list is neither sponsored nor endorsed by Invensys Process
Systems (formerly The Foxboro Company). Use the info you obtain here at
your own risks. Read http://www.thecassandraproject.org/disclaimer.html
 
foxboro mailing list:             http://www.freelists.org/list/foxboro
to subscribe:         mailto:foxboro-request@xxxxxxxxxxxxx?subject=join
to unsubscribe:      mailto:foxboro-request@xxxxxxxxxxxxx?subject=leave

Other related posts: