RE: Setting parms in CL for PF

["Gary Monnier" <gary.monnier@xxxxxxxxxxxxx>]

James,

Have you thought about modifying the process that reads File1 to submit
multiple jobs?  You could jobs that only process a set of distinct
entries - say one job processes entries for customer A and another
processes entries for customer B and so forth.  To do this type of thing
one way is to put a logical over File1 that is sequenced in the order
you wish to process.  The process reading File1 could then do the
following.

1. Position File1 to its starting point with, in RPG, SETLL.
2. Read Flie1 by key until end of file.

This will cause your program to only process those entries you want it
to process.

If you are up for rewriting the process you could also use embedded SQL
to select and sequence the entries a job is to process.

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of James R. Newman,
CDP
Sent: Thursday, October 14, 2004 9: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.