Re: Batch problem

["Arlene M Soderlund" <Arlene_M_Soderlund/NFCNA.COM@xxxxxxxxx>]

"alan shore" <SHOREA@dime.com> on 11/01/99 08:11:46 AM

If they are both physical files, how about deleting the logical files first,
running the batch program to add the records to the physical files and then
create logical files over the physical file.

>>> "kennyy" <kennyy@telebot.com> 11/01 5:04 AM >>>
Hi, can anyone please help.
I have a batch program which read a file about 1 million record and write to
two files with 11 milliom & 6 million record. Both of the output file have keyed
logical file with it. Please advice how to reduce the batch processing time
which current running for 2 hour.



You really don't need to delete the logicals, instead run DSPDBR and DSPFD both
to an outfile (DO a logical JOIN after to read in a CL) to get the status of the
Logicals, whether they are on *Immed,*DLY or *Rebld.  Change all logicals over
the files to *Rebld.  After copying, do a chglf to change back to *Immed or
*DLY, then the IBM data base jobs will build the access path at least two at a
time. Also the fastest cpyf is to start at record 1, not *Start if the PF has
it's own access path. (Unless you want the reorganization this provides.)






+---
| This is the RPG/400 Mailing List!
| To submit a new message, send your mail to RPG400-L@midrange.com.
| To subscribe to this list send email to RPG400-L-SUB@midrange.com.
| To unsubscribe from this list send email to RPG400-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---