Hi.

1.- True. "onstat" shows status from INFORMIXSERVER dbserver, on all its
options. By changing INFORMIXSERVER value you should see selected server.

2.-You have several options if you are using UNIX. My personal choice is
setting INFORMIXSERVER by user profile when I know which users will use
which server. If choice depends on application, you can define connection
at the beginning of the program ( example: "DATABASE data@server1" in 4GL).
Finally, for sui-generis users who wants to connect to each server as they
like, they should reset INFORMIXSERVER as they will (or create scripts to do
it so)

3.- Nice request. By now, you can execute an "echo $INFORMIXSERVER" after
each onstat, or you can create shell scripts or alias which do this for you
(on Unix)

Everything I wrote before I have done for Solaris 7/8 & IDS
9.30/9.40

Later

Omar Muqoz

----- Original Message -----
From: "Mike Badar" <mbadar@esri.com>
To: <informix-list@iiug.org>
Sent: Wednesday, February 01, 2006 4:40 PM
Subject: Multiple instances


> Greetings, I have been asked to setup two DB servers on the same box for
> development purposes. I have two questions related to multiple DB
> servers:
>
> 1. When "onstat -" is run, is IDS returning the status for the DB server
> based on the current value of the environment variable, INFORMIXSERVER?
>
> 2. What would be the best way to switch between each DB server; ie,
> scripts, separate user accounts which would set the appropriate
> environment variables to point to the proper DB server, ...?
>
> 3. Maybe a feature request would be to have onstat return the name of
> the DB server it is referencing?
>
> Your suggestions regarding questions 1 and 2 would be greatly
> appreciated.
>
> Thanks for your time.
>
> Mike Badar
> ESRI-Denver
> 1 International Court
> Broomfield, CO 80021-3200
> 303-449-7779
> mbadar@esri.com
> www.esri.com
> _______________________________________________
> Informix-list mailing list
> Informix-list@iiug.org
> http://www.iiug.org/mailman/listinfo/informix-list
>