RE: Setting parms in CL for PF - follow up

[Steve Morrison <smorrison@xxxxxxxxxxxxx>]

James, 
Let us know what kind of performance difference you see. Are any of the 5
fields you update used in the key for FILE2LF? 


Steve Morrison
Beacon Insurance
940-720-4672 

-----Original Message-----
From: James R. Newman, CDP [mailto:newman400@xxxxxxxxxxx] 
Sent: Friday, October 15, 2004 11:58 AM
To: Midrange L
Cc: vhamberg@xxxxxxxxxxx
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.