RE: copy database

Except for one thing that's not in the manual . . . . (I looked, hopefully well) IF your beta-test system has the same logical layout (chunks) as the production system and IF the versions of Informix are identical and IF you don't mind making certain ONCONFIG variables the same on test as your production system THEN you can take a level 0 ontape archive on your production system and restore it to test. Certainly faster than export / import if you want the data copied to test. OR IF all you want is the database structure . . . then read the fine manual under "DBSCHEMA". John Carlson Informix DBA EDS - WHSmith USA 3200 Windy Hill Road, Suite 1500 West Atlanta, GA 30330 > -----Original Message----- > From: Obnoxio The Clown [mailto:obnoxio@hotmail.com] > Sent: Tuesday, August 29, 2000 9:08 AM > To: martin@math.unl.edu.ar; informix-list@iiug.org > Subject: Re: copy database > > > From: "Martin A. Marques" <martin@math.unl.edu.ar> > > > >We have a databse that has gone on production, so we want to copy the > >database structure (with or without the contents, it's the > same), to a > >beta-test base, so we can make new improvements. > >How is this done? > > Jeez, will you *ever* read a manual? :-( > > Try the Informix Migration Manual for this one. > > ______________________________________________________________ > ___________ > Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. Share information about yourself, create your own public profile at http://profiles.msn.com.

> > IF your beta-test system has the same logical layout (chunks) as the > production system and -- it depends on what you need the copy for. If you want to have a test DB which is identical to the productive system just to test the new programs on it without risk of damaging productive data - then you really need a copy, possibly regularly actualised. In this case you must have the same chunk layout. > IF the versions of Informix are identical and -- I suppose they are... > IF you don't mind making certain ONCONFIG variables the same on test as your > production system -- You need exactly the same ONCONFIG parameters only during the restore. You can change them after it. > THEN you can take a level 0 ontape archive on your production system and > restore it to test. > > Certainly faster than export / import if you want the data copied to test. Sure. We tried both. We exported / imported one of our database of a size appr. 100 GB. It took about 4 days. Recovering a level 0 backup with onbar and a fast jukebox takes appr. 5 hours. But! Export / import has the advantage that you reorganize your database. Regards Peter -- Peter Dzvonyar SAP-Consultant R/3 BC _______________________________________________________________ email: sap-ext-001@ops.de p.dzvonyar@t-online.de _______________________________________________________________