Re: I-NET and server with multiple instances -- HELP
ACK-NAK wrote:
> 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
Correct. Each instance needs a distinctive port entry in the "services" file.
These entries must be identical for each networked machine involved!
> Then in sqlhosts:
>
> db01soc olsoctcp host01 db01srv
> db02soc olsoctcp host02 db02srv
Correct.
> 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
Almost correct. The service name from the "services" file must be passed to
"sqlexecd" as an argument, so the startup command for sqlexecd must read
# $INFORMIXDIR/lib/sqlexecd db01srv -l $logdir/db01.log
or
# $INFORMIXDIR/lib/sqlexecd db02srv -l $logdir/db02.log
If you are connecting from a PC using I-Net, you must enter the correct
service name for the instance you want to connect to in the ODBC setup.
HTH, Richard
--
+--------------------------+------------------------------------------+
| Dr. Richard Spitz | INTERNET: spitz@ana.med.uni-muenchen.de |
| EDV-Gruppe Anaesthesie | Tel : +49-89-7095-3413 |
| Klinikum Grosshadern | FAX : +49-89-7095-8886 |
| 81366 Munich, Germany | GSM : +49-172-8933578 |
+--------------------------+------------------------------------------+