Re: Most used files?

[MacWheel99@xxxxxxx]

There's statistics in DSPFD regarding which files get hammered the most in 
terms of reads, updates, and so forth.  DSPFD can be *OUTFILE then Query 
against that ... I have a Job Scheduler deal that runs in the wee hours twice 
a week doing DSPFD on all files all libraries to *OUTFILE in a library just 
for such statistical analysis, followed by a Query that gives me statistics 
that tip me off that various actions needed on which files, usually reorg to 
remove deleted records.

> From: sallen@fellowes.com (Allen, Stu)
>  
>  I'm looking at changing the access path size on some of our most heavily
>  contended files from *max4gb to *max1tb.
>  Whilst i have a fair idea if which files get hammered the most, does anyone
>  have a way of monitoring this so that i can cherry pick those that are 
going
>  to give the greatest benefit?
>  
>  Regards,
>  Stuart


Al Macintyre  ©¿©
http://www.cen-elec.com MIS Manager Programmer & Computer Janitor

Y2K is not the end of my universe, but a re-boot of that old Chinese curse.
This message was written and delivered using 100% post-consumer (recycled) 
data bits
The road to success is always under construction.
Accept that some days you are the pigeon and some days the statue.
Murphy's Mom brought wrong baby home from hospital so it should be Kelly's 
Law.
If consistency is the hobgoblin of little minds, only geniuses work here.
When you want it cheap - you get what you paid for.
When in doubt, read the manual, assuming you can find the right one.
+---
| 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
+---