Re: I-NET and server with multiple instances -- HELP

In article <01bddcc4$ac859be0$eb74800f@beetle> "Sebastien Spieser" <sebastien_spieser@non-hp-france-om5.om.hp.com> wrote: > Hello, > > I'm using online 5.03 server: we have several database servers running, and > 1 or 2 instances inside one server (hope it's clear enough). > > Can u help me configuring Informix-NET (9.02) ? I can connect to one > database, but none of the other ones !! > (in Unix, it's a matter of export TBCONFIG=... to switch from one to > another..) > > Thx > Sebastien My guess is that you have only one instance of sqlexecd running. You need to define an entry in /etc/services for each instance. eg. db01srv 8000/tcp db02srv 8001/tcp Then in sqlhosts: db01soc olsoctcp host01 db01srv db02soc olsoctcp host02 db02srv Of course you could always have the same name for both the servername and servicename. Now su to root and set your tbconfig and start sqlexecd for each instance: # TBCONFIG=tbconfig.db01 # export TBCONFIG # $INFORMIXDIR/lib/sqlexecd db01 -l $logdir/db01.log # TBCONFIG=tbconfig.db02 # export TBCONFIG # $INFORMIXDIR/lib/sqlexecd db02 -l $logdir/db02.log Check your I-Star manual to verify the above syntax. -- Alvin Koh <mailto:alvin_koh@singpost.com>