Re: Setting parms in CL for PF

[Vernon Hamberg <vhamberg@xxxxxxxxxxx>]

If this will be running by itself, change maintenance on the logical to 
*DLY - every update to a record involves updating the logical, so that 
could add a lot to the time. At the end, put maintenance back to *IMMED. 
You could do the same for FILE2 itself, so long as it does not use its own 
index. Also, unique indexes can't use the delayed option, IIRC.

FRCRATRIO should at least not be set to 1 - *NONE might be feasible.

HTH
Vern

At 11:32 AM 10/14/2004, you wrote:
> I've got a 9406-600 running V5R2 and have to run a large update job about 
> once a month.  File1 is a sequential, non-keyed PF containing about 18 
> million records of updated "current" information.  File2 is a keyed PF 
> "master" with 18 million+ records that will be updated from File1.  File2 
> has 1 logical.
>
> A friend suggested changing some of the OVRDBF parms to help processing go 
> faster, such as FRCRATIO and NBRRCDS.  Any suggestions on how to set these 
> parms?  For that matter, any suggestions on how to speed up the update 
> process?  TIA.
>
>
> James R. Newman, CDP