RE: How to optimize COPY *ADD

[Buck Calabro <Buck.Calabro@xxxxxxxxxxxx>]

Dmitri E wrote:
>We use to make copy - add to historical file (PF + 18 LFs)
>daily. That means to copy 4000000 records, which takes 
>about 6 hours using normal CPYF command. 

Several thoughts:
1) On the CPYF, try FROMRCD(1).  This will tell CPYF to read the source file
in sequential order rather than by key.
2) 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) and so on.
3) If the application allows it, put a trigger on the transaction file to
copy each record to the history file as they are added to the transaction
file.  Then the index update load is spread through the entire day instead
of all at once.
4) Along the same lines, perform the CPYF many times throughout the day
instead of once.

I realise that your application may not like any or all of these
suggestions, but perhaps it will help to stimulate others to better ideas!

Buck Calabro
Commsoft; Albany, NY
Visit the Midrange archives and FAQ at http://www.midrange.com
"Where so many hours have been spent convincing myself that I am right,
 is there not some reason to fear that I may be wrong?" -- Jane Austen
+---
| 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
+---