Re: Setting parms in CL for PF - follow up 2

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

1.  None of the 5 fields tested are part of the key in the LF.

2.  I got the 32000 size on NBRRCDS and FRCRATIO because the actual upper 
limit was something like 32676 and I was too lazy to go back to help to find 
the exact number.  I picked the large number thinking "pull more records 
into memory = faster processing", right?

3.  Month-to-month, there's probably an equal number of adds and updates to 
the master file - about 40,000 of each.


I'll post the run times when completed.



----- Original Message ----- 
From: "James R. Newman, CDP" <newman400@xxxxxxxxxxx>
To: "Midrange L" <MIDRANGE-L@xxxxxxxxxxxx>
Cc: <vhamberg@xxxxxxxxxxx>
Sent: Friday, October 15, 2004 11:58 AM
Subject: Setting parms in CL for PF - follow up


Thanks for the great input on changing the CL for updating this big file.

Here's the changes I've made and plan to run over the weekend.  Would 
someone tell me if this looks right?  FILE1 is the sequential input and 
FILE2 is the indexed output with 1 logical:


CHGLF   FILE(FILE2LF)  MAINT(*DLY)

OVRDBF  FILE(FILE1) NBRRCDS(32000)  SEQONLY(*YES)
OVRDBF  FILE(FILE2) FRCRATIO(32000)
CALL  PGM(BIGFREAKINUPDATE)

CHGLF   FILE(FILE2LF)  MAINT(*IMMED)


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.