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

Hi Dave

Educate me. How would you do this on a "real" DBMS ? Would the statistics
collected by the database tell me ?

Regards
Evan Harris

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Dave Odom
Sent: Thursday, 22 November 2007 9:05 a.m.
To: midrange-l@xxxxxxxxxxxx
Subject: Re: How can I determine "hit rate" for a set of files in

Thank you to all that help me get the info I needed. The answer is DSPFD at
the *MBR level output to a table where I can use QMF to do the queries I
need and figure out a breakpoint between High, Medium and Low file
volatility.

I wish I could have used a DBMON-type of function but as DB2/400 is not
quite a real RDBMS, as it uses back doors with keyed sequence file access
and not strictly SQL, it seems that this option is not available.

Thanks again,

Dave