AW: Multiple instances

Mike Badar wrote: > 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? Partially correct, you'd want to make sure that $ONCONFIG is set correctly , too. (need SERVERNUM) . Also, incase you use different installation directories , you need set INFORMIXDIR, too. > > 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, ...? > Set up two informix users (e.g. inftst and infprd) > 3. Maybe a feature request would be to have onstat return the name of > the DB server it is referencing? > use onstat -g env

>use onstat -g env Very cool, I did not know this. Thanks.