Re: This possible?

kistler@an.hp.com (Jim Kistler) wrote: :Will this work? : : - Upgrading a production database to new revisions of OnLine and ISQL. : : - Goal is to compile and test all forms and reports with the upgraded : software WITHOUT INTERFERING WITH THE EXISTING PRODUCTION DATABASE. : : - Set up new OnLine and ISQL as a separate instance running on the : same CPU. For testing, set $INFORMIXDIR to point at the new versions : of the software. : :?- Do I have to "clone" the production database structure for testing : or is it possible for both OnLine engines to access the SAME shared : memory? The same disk areas you mean? No. You have to create a separate database. It should be easy enough to use dbschema and rebuild it if all you need is the structure. If you have space for it you might want to use dbexport/dbimport to move all the data as well. :?- If two instances of the OnLine engine address the same shared memory : segment, are there any problems anyone has discovered in doing this? They never do. You set them up with differen values for "SERVERNUM" in you onconfig file and they will run side by side quite nicely. You will of course have to have enough memory to run both at the same time. For development/testing only you can of course set up the new one with minimal resource usage until you want to use it for production. Some weeks ago there where a thread describing everything you should do during such an upgrade. You might want to find that. Check http://www.dejanews.com Those posts realy belong in the faq as well. Nils.Myklebust@idg.no NM Data AS, P.O.Box 9090 Gronland, N-0133 Oslo, Norway My opinions are those of my company The Informix FAQ is at http://www.iiug.org