Unix Technical Forum

AW: Multiple instances

This is a discussion on AW: Multiple instances within the Informix forums, part of the Database Server Software category; --> Mike Badar wrote: > Greetings, I have been asked to setup two DB servers on the > same box ...


Go Back   Unix Technical Forum > Database Server Software > Informix

FAQ Members List Calendar Search Today's Posts Mark Forums Read
  #1 (permalink)  
Old 04-20-2008, 11:26 AM
Model-Bosch, Tilman
 
Posts: n/a
Default 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

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #2 (permalink)  
Old 04-20-2008, 11:27 AM
bozon
 
Posts: n/a
Default Re: Multiple instances

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

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On
Forum Jump


All times are GMT. The time now is 05:28 PM.


Powered by vBulletin® Version 3.6.5
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Search Engine Optimization by vBSEO 3.2.0
www.UnixAdminTalk.com