RE: Data migration time tests.....

["John P. Walsh" <john_walsh@xxxxxxxx>]

Please send the referenced article.  Thanks.

John
john.walsh@icdc.com

> -----Original Message-----
> From: owner-midrange-l@midrange.com
> [mailto:owner-midrange-l@midrange.com]On Behalf Of Gallagher, Debbie
> Sent: Friday, June 25, 1999 8:07 PM
> To: MIDRANGE-L@midrange.com
> Subject: RE: Data migration time tests.....
>
>
>
> 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
> +---
>

+---
| 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
+---