Re: accessing the records in a history file

["Al Barsa, Jr." <barsa2@xxxxxxx>]

At 04:44 PM 12/21/00 +0000, you wrote:

Correct selection criteria through SQL or OPNQRYF will dramatically reduce 
the overhead.  A LF based on date in the proper sequence would help that 
process even more.  Both OPNQRYF and SQL use the same underlying engine in 
the system.

And while I have the floor, Merry Christmas to all.

Al

>I'd like some insight from folks on this scenario:  There is a history
>file of records dating from 1994.  Records are added each day and now
>there are 3.6 million records in the file.  The odds of anyone going back
>to look up something in 1994 are slim but management won't purge any
>records.  Obviously the newest records are at the end of the file.  All of
>the logicals have the customer ID number as the first key. One logical has
>a key of the customer ID and then date and time.
>
>Each business day there is at least one and sometimes five or more reports
>written for all activity during some recent time period (a workshift, a
>day, a week, whatever).
>
>This process is becoming a performance pig; additionally there is a need
>for more function.   What sorts of suggestions do you people see as
>possible enhancements to this?  SQLRPGLE? OPNQRYF? a new Logical on date
>and time alone? #GSORT?
>
>Any suggestions are appreciated.  thanks in advance.
>
>
>_______________________
>Booth Martin
>Booth@MartinVT.com
>http://www.MartinVT.com
>_______________________
>+---
>| This is the Midrange System Mailing List!
>| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
>| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
>| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
>| Questions should be directed to the list owner/operator: david@midrange.com
>+---



+--------------------------------------------------+
| Please do not send private mail to this address. |
| Private mail should go to barsa@ibm.net.         |
+--------------------------------------------------+

Al Barsa, Jr. - Account for Midrange-L
Barsa Consulting Group, LLC.    
400 > 390

Phone:          914-251-1234
Fax:            914-251-9406
http://www.barsaconsulting.com
http://www.taatool.com

+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---