RE: How to optimize COPY *ADD

[Joel Fritz <JFritz@xxxxxxxxxxxxxxxx>]

I'm sorry, I wasn't clear.  I meant keyed sequence in the daily file.  I was
suggesting that you copy the  records from the daily file in arrival
sequence.  If the daily physical is unkeyed, you're probably already doing
that.  Splitting into smaller parallel copies should give you a boost.

> -----Original Message-----
> From: Dimitri Efimov [mailto:defimov@wiese.com.pe]
> Sent: Friday, July 27, 2001 12:37 PM
> To: MIDRANGE-L@midrange.com
> Subject: RE: How to optimize COPY *ADD
> 
> 
> That's correct, we are copying daily built file to history 
> file, the point
> is - the history file has more than 200 mln. of records, even 
> more - it has
> 18 index files. So it's impossible to find "keyed sequence". 
> 
> But I'm going to try the solution Buck's solution ("Multiple 
> CPYF commands
> in parallel might be better if you have a good way to 
> partition the records
> such as FROMRCD(1)
> TORCD(1000000)...FROMRCD(1000001) TORCD(2000000) ...) hope it 
> will work. 
> 
> Thanks a lot 
> 
> Dmitri Efimov
> Banco Wiese Sudameris
> 
> DEF
> 
> -----Mensaje original-----
> De: Joel Fritz [mailto:JFritz@sharperimage.com]
> Enviado el: Viernes, 27 de Julio de 2001 01:25 p.m.
> Para: 'MIDRANGE-L@midrange.com'
> Asunto: RE: How to optimize COPY *ADD
> 
> 
> If I understand you correctly, you're copying a file that's 
> built daily to a
> history file.  Six hours sounds like a long time for 
> 4,000,000 records.  Are
> you copying in keyed sequence?  If you are you could try fromrcd(1).  
> 
> Otherwise, you could break it down into "simultaneous" 
> submitted jobs using
> fromrcd(x) torcd(y). 
> 
> +---
> | 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 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
+---