Re: Xfer from Test to Devel

Naibin Chen wrote: > > Carlson@WHSmith wrote: > > > Steve Romankiw wrote: > > > > > > When we transfer between Test and Development (located on same machine), I > > > typically do an DBEXPORT from test followed by an DBIMPORT into > > > development. This is a slow process. > > > > > > > Sounds like you're looking for a full dataset. > > > > > Are other options available? For instance, can I create a onpload image > > > of my test environment, unload test, and reload into development using the > > > image. > > > > We've been quite successful in restoring a production level0 archive to > > our test system. We have identical logical layouts between systems. > > MUCH faster than dbexport/dbimport or unload/load. > > > > John Carlson > > Informix DBA > > WH Smith, Inc. > > I have identical logical layouts for Prod db instance and Test db instance on > thesame Unix machine, because they have different instant name I wasn't able to > Xfer > with ontape and have to use dbimport. Does your systems located on the same > machine or on a different machine? You can restore to a different instance name and server number, I'm doing it now. The database chunk devices/files have to have the same names that is the problem with restoring between instances on the same machine. Art S. Kagel