Re: Xfer from Test to Devel

In article <35DD8FA3.5672@bellsouth.net>, Carlson@WHSmith <carlson1@bellsouth.net> writes >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. >> > onunload and onload. Runa script to first create the required tables with the required extent sizes. Then onload several tables in parallel then create indexes.. >> > > 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? >> >> Naibin Chen > >Oh great . . . NOW I actually read the original post. Unfortunately, >the words "same machine" are just now registering. Too much coffee, I >guess . . . 8-) > > >My recommendation will work where test and prod are on different boxes. >Unfortunately, the only thing that I know would work on the same box >would be 'dbexport/import', 'unload/load', or 'onunload/onload' > >Sorry for the confusion . . . > > >John Carlson >Informix DBA >WH Smith, Inc. -- David Williams Maintainer of the Informix FAQ Primary site (Beta Version) http://www.smooth1.demon.co.uk Official site http://www.iiug.org/techinfo/faq/faq_top.html I see you standin', Standin' on your own, It's such a lonely place for you, For you to be If you need a shoulder, Or if you need a friend, I'll be here standing, Until the bitter end... So don't chastise me Or think I, I mean you harm... All I ever wanted Was for you To know that I care