Re: Setting parms in CL for PF - Results

[Rich Duzenbury <rduz-midrange@xxxxxxxxxxxxxxxxxxx>]

On Mon, 2004-11-01 at 12:35, James R. Newman, CDP wrote:
> I posted several weeks ago about trying to update a large PF and
> making CL changes to speed up the process.  Several of you made
> suggestions so here are the results.
Sorry, I missed this thread.
> 
> Each time I did a pass, I first cleared the PF.  I ran the update with
> all 18 million records so each record had to be written to the PF. 
> Next, I ran the update again so that it attempted to update each
> record.  I ran 3 passes:
30+ hours seems excessive.  Perhaps you are using a very small machine?

Are the records really large? The transaction file on the systems I work
with are normally in the 8-15 million range, and I never worry that any
kind of update might take 30+ hours.  

Can we see the code for bigfreakinupdate, and the layouts for the PF's?

Also, what do the joblogs for these jobs look like?
--
Regards,
Rich

Current Conditions in Des Moines, IA
Overcast
Temp 48.2F
Winds out of the Northeast at 16mph
Light Rain Moderate Mist