RE: accessing the records in a history file

[Chris Bipes <chris.bipes@xxxxxxxxxxxxxxx>]

Move records to a history library and only keep current stuff.  Build a LF
over both for management to see all history.  They never have to know that
the data is in two different files in two different libraries.  You did not
purge anything, just moved it.


Christopher K. Bipes    mailto:ChrisB@Cross-Check.com
Sr. Programmer/Analyst  mailto:Chris_Bipes@Yahoo.com
CrossCheck, Inc.        http://www.cross-check.com
6119 State Farm Drive   Phone: 707 586-0551 x 1102
Rohnert Park CA  94928  Fax: 707 586-1884

If consistency is the hobgoblin of little minds, only geniuses work here.
Karen Herbelin - Readers Digest 3/2000

-----Original Message-----
From: booth@martinvt.com [mailto:booth@martinvt.com]
Sent: Thursday, December 21, 2000 8:44 AM
To: midrange-l@midrange.com
Subject: accessing the records in a history file


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.
+---
| 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
+---