• Subject: Re: SAVRSTLIB
  • From: John Hall <jhall@xxxxxxxxxxx>
  • Date: Wed, 13 Jan 1999 15:13:14 -0500

Roger Boucher wrote:
> This is perhaps a bit off the thread here, but I have a job running each
> night that copies our Production data library to a Production Test
> environment's data library, thereby refreshing it each night with
> yesterday's production data.  I threw together a quick CL that does a
> CLRLIB followed by a CPYLIB.  This process is beginning to take too
> long.  Can anyone help me with the best (quickest) way to accomplish
> this... besides getting into SAVACT.  I hope the answer isn't SAVACT but
> I'll accept that if it is.
> :-)
> Thanks for your help.

We have done the same thing in the past.  Couple of suggestions;

1) don't delete the files & re-create them.  The creating & deleting
large numbers of files causes LOTS of system overhead.

2) Write a CL program that does a CPYF FRMRCD(1) FMTOPT(*NOCHK) for each
physical file.  This is much quicker and can be run while the files are
in use.  If there are too many files write a query that creates a list
of them in a PF and run the CPYF command for each file.

3) Run this in batch (Especially if you have server machine) and make
sure the job has plenty of memory.  If you have a multiple CPU system
split the Job up otherwise just process them one at a time.

4) You may be able to set the access path Maintenance to *DLY if most of
the files are not going to be used for testing in a given day.  This
will not work on uniquely keyed files however.

5) If you have logicals built over very large files you may wish to
consider deleting them (in the test Library) before the copy and
recreating them after.  Sometimes this makes a big difference -
sometimes it doesn't


John Hall
Home Sales Co.
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com

This thread ...


Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2019 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].