Re: How to Create another instance of Informix?

On 1 Oct 1998 00:56:48 GMT, esquivelr@aol.com (EsquivelR) wrote: > >Look up "Multiple Residency" in the Online Administrator's CD or the Online >Administrator's Manual. It lays out the exact procedure for what you want to >do. We are using multiple residency for Baan IV for Production & Development >instances. One is completely cooked and the other raw. We've had no trouble so >long as you follow the instructions they specify. Additionally, create a new >login (say informix5 for Baan 5) and then edit /etc/passwd and set the uid to >the same as user informix. Then have this login point to the new instance. >Trust me this will save you the agony of bringing down the wrong instance or >dropping chunks off the wrong instance! You shouldn't create separate login's for separate instances. The master login for server maintenance has to be "informix" and nothing else. If you do as you have done it may sometimes work, but a simple thing like having the informix5 entry before the informix entry in /etc/passwd will make it fail. There are other faliure modes as well. Look in the manual. It says the login *must* be informix. It's very easy to create a file that you can source that set's the appropriate environement variables (including the prompt). You could even easily make a small menu at login that asks you for what instance you want to work with. This is at least as secure against the danger of bringing down the wrong instance or other similar issues as a separate login. Nils Myklebust NM Data AS Norway E-mail: Nils.Myklebust@nmdata.com FAQ at: http://www.iiug.org/techinfo/faq/faq_top.html (Now with ODBC info under "Third party products".)