SEO

#1 (**permalink**) 04-20-2008, 10:26 AM

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

#2 (**permalink**) 04-20-2008, 10:27 AM

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

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SEO

AW: Multiple instances