Re: Setting up a Test Env

Adam Sorati wrote: > > Eng: online 7.23.UC1 > OS: AIX 2.4.1 > HW: 1x166Mhz CPU, 128MG RAM and 2x4.5GIG disk. > DB: 1.3 GIG > 242 Tables > > Has anyone got any thoughts on the best way to > set up a development environment. > I was thinking of setting up another instance > for the development (dev) DB. That's generally the way to do it. Just be very careful to set your environments correctly for each type of user. Consider you 'default' instance. You can have no default instance by not using the onconfig file at all. If the default is the live one, developers can 'play' with the live data by mistake. If the default is the dev one, new users could update test data instead of live data. > In the dev DB. I was thinking I could make the > logical logs a lot smaller as it is 360 MG in > the prod DB. I was also going to make the resident > portion of the shared memory smaller. That will work, as long as you have enough resources for your applications. > Q: Is there any way I can have the logical log > but not need to back it up at all for the dev DB. Yes. Just set your logical log device to /dev/null, and OnLine will throw away the logs for you. Hope that helps, -- Mark. +----------------------------------------------------------+-----------+ |Mark D. Stock - Informix SA http://www.informix.com |//////// /| |mailto:mdstock@informix.com FAQ http://www.iiug.org |///// / //| | +-----------------------------------+//// / ///| | Tel: +27 11 807 0313 |If it's slow, the users complain. |/// / ////| | Fax: +27 11 807 2594 |If it's fast, the users keep quiet.|// / /////| |Cell: +27 83 250 2325 |Therefore, "No news: travels fast"!|/ ////////| +----------------------+-----------------------------------+-----------+