We use Netbase to shadow data to a second computer for archival/reports/etc.

Also I used to use the simple DB2DISC and it's companion from the CSL tape to
dump data from a database to a flat file and vice-versa. Never used it with
large databases though.

"Trudeau, James L" wrote:

> Howdy,
>
> Well yeah, you could restore the detail and it's master(s).  Then, assuming
> that the production
> database has been updated during the 13-14 hours, you can go deal with the
> root file.  Also
> assuming this is not a one_shot_deal you can ENSURE that the proper tapes
> are being restored
> at the proper time.  Now that we've got that out of the way, I'd like to
> make you a bet.  My best
> heifer against nothing that sooner or later something is going to go bump
> and you will have a really
> hosed (tech term) production database.  Partial restores are something to be
> dealt with under
> very controlled and specifc circumstances.
>
> You don't say what kind of boxes you've got nor how many links into the
> detail set.  If it's a
> pretty simple setup you might try - 1) process on test box 2) extract the 8
> million recs to a
> plain jayne file 3) somewhere during #2 erase (Adager? DBgeneral? custom
> prog) the production
> dataset 4) load (Suprtool, custom prog?) the flat file to the production
> data set.  Probably take
> awhile on the load to production but it should significantly less than 13-14
> hours, depending
> on the box the database complexity.....blah, blah.
>
> Now before you go thru all that, are you certain you have everything
> optimized in the production
> environment?
>
> wel the users sing me their siren song - gotta run
>
> Jim Trudeau
>
> On Tuesday, December 15, 1998 11:42 AM, [log in to unmask]
> [SMTP:[log in to unmask]] wrote:
> > We have a test box and a production box.  We run processes on the test box
> to
> > offload them from the production box.  A particular process requires 13-14
> > hours on the production box to populate an 8-million record TurboImage
> > dataset.  The same job on the test box requires about the same amount of
> > time. The benefit of running on the test box is that cpu processing time
> is
> > not being consumed on the production box.
> >
> > If one was to back up the datafile (Image master and detail files) on the
> test
> > box, is it safe to restore that file onto the production box?  I don't
> know
> > enough about how image databases and image root files work to say if this
> will
> > cause problems.
> >
> > Your input is greatly appreciated.  Thanks.
> >
> > -----------== Posted via Deja News, The Discussion Network ==----------
> > http://www.dejanews.com/       Search, Read, Discuss, or Start Your Own