Re: Creating Logicals before or after populating a file ?

[Larry Bolhuis <lbolhui@xxxxxxx>]

Evan,
 
  ABSOLUTELY and POSITIVELY Option 1 is better.

  Been there, Done that, Ate the stale pizza.

  If you would like a discussion of why this is true, just ask.. 

  Larry Bolhuis
  Arbor Solutions, Inc
  lbolhui@ibm.net


Evan Harris wrote:
> 
> We are about to embark on an exercise that will populate a *large*
> database file (40 million records plus). This file has about 20 logical
> files built over it.
> 
> My question is, which is more efficient:
> 
> 1. Populating the file and building the logicals ?
> 
> 2. Building the logicals and populating the file ?
> 
> Any thoughts would be greatly appreciated.
> 
> Cheers,
> Evan Harris
> +---
> | 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
+---