Re: How can I determine "hit rate" for a set of files in libraries

DSPFD ... TYPE(*MBR) :


Data Space Activity Statistics . . . . . :
Data space size in bytes . . . . . . . : 184397824
Physical file open accesses . . . . . . : 118
Physical file close accesses . . . . . : 118
Write operations . . . . . . . . . . . : 6,426
Update operations . . . . . . . . . . . :
Delete operations . . . . . . . . . . . : 4,888
Logical Reads . . . . . . . . . . . . . : 1,691,332
Physical Reads . . . . . . . . . . . . : 2,877
Clear operations . . . . . . . . . . . :
Data space copy operations . . . . . . :
Reorganize operations . . . . . . . . . : 1
Access paths builds/rebuilds . . . . . : 11
Records rejected by key selection . . . :
Records rejected by non-key selection . : 2,106
Records rejected by group-by selection. :

On Nov 20, 2007 4:47 PM, Dave Odom <Dave.Odom@xxxxxxxxxxxx> wrote:

Gang,

I need a way to tell the volume of activity (Inserts, Updates, Deletes),
over time, on all files in certain libraries? Short of going against the
journals, is there another way to capture and group the "hit rate" for files
grouped by HIGHEST, MEDIUM and LOW or at least a way to show file "Hit rate"
and I'll group.

Thanks in advance,

Dave Odom
Arizona
--
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.