Re: Setting parms in CL for PF

["James R. Newman, CDP" <newman400@xxxxxxxxxxx>]

I'm reading a record in File1 and chaining to File2.  If no record is found, 
it writes to File2.  If record is found, it then checks about 5 fields and 
if the fields are identical in both records, no update is performed.  If 
they're not the same, the info from File1 is moved and written to File2.



----- Original Message ----- 
From: "Steve Morrison" <smorrison@xxxxxxxxxxxxx>
To: "Midrange Systems Technical Discussion" <midrange-l@xxxxxxxxxxxx>
Sent: Thursday, October 14, 2004 1:41 PM
Subject: RE: Setting parms in CL for PF


> James,
>
> I'll assume that this program reads FILE1 and chains to FILE2 to update 
> it.
>
> The first thing I'd do is try to index or sort FILE1 so that it's in the
> same basic order as FILE2. This will allow the system to cache the
> reads/updates to FILE2. This change shouldn't require changing the update
> program.
>
> A couple of questions:
> Are there multiple updates in FILE1 for records in FILE2, or is there only
> one update in FILE1 for any record in FILE2?
>
> Are the updates changing fields that are used in an index over FILE2?
>
> Steve Morrison
> Beacon Insurance
> 940-720-4672
>
> -----Original Message-----
> From: James R. Newman, CDP [mailto:newman400@xxxxxxxxxxx]
> Sent: Thursday, October 14, 2004 11:32 AM
> To: Midrange L
> Subject: Setting parms in CL for PF
>
> 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
> --
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing 
> list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe, 
> unsubscribe,
> or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take a
> moment to review the archives at http://archive.midrange.com/midrange-l.
>
> --
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing 
> list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.