RE: Data migration time tests.....

["Gallagher, Debbie" <dgallagher@xxxxxxxxxxx>]

When we did this at the last place I worked (lots of big files), we found
every 
time that it was faster to rmvlfm then update the physical than addlfm. And
in 
many cases, it was a LOT faster.

Also, when you build the logicals afterward, do the ones with the most keys 
first. E.g. do the logical with FLDA, FLDB, FLDC before the one with FLDA,
FLDB.
The system will automatically share the access path. I have done testing on
this
and it really does work. If you want the article I wrote on this subject for
the
Toronto Users Group Magazine, email me and I'll send it to you.

Debbie Gallagher

______________________________ Reply Separator
_________________________________
Subject: Data migration time tests.....
Author:  "Anthony Haines" [SMTP:AHaines@macmanus.com] at Internet-CA
Date:    6/25/99 11:23 AM


We are in the process of mirgating some of our data from one PF to another
for 
several files (adding fields and expanding others).   A few large files are 
going to take us a long time to convert. (+40millon records with several 
logicals)     We're running V3R2
     
My questions is:   Is it faster to build the LFs before or after the data is

moved into the files?
     
Suggestions/Recomendations?
     
+---
| 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
+---