Re: Clarification of DSPFD output

[Larry Bolhuis <lbolhui@xxxxxxx>]

I may be wrong here (already over my limit for the year so what the
heck) but I always believed that the Logical reads were the total
number of reads while Physical reads were those that did not came from
DB pages already in main storage - that is they required a physical
disk read.

 = Larry

Kris Vaidyanathan wrote:
> 
> When you do a DSPFD on a file on the there is some info that I need
> clarification on.
> I have a file that says the following..
> 
> Open Operations......................................77,875
> Close Operations......................................77,875
> Write Operations.......................................16,940
> Update Operations....................................0
> Delete Operations.....................................16,940
> Logical Reads........................................513,079,190
> Physical Reads......................................201,016,762
> 
> This is a highly volitile file used for passing trigger info around and I
> understand the Open Closes and Write/Update/Delete numbers.
> What do the Logical and Physical reads mean. This is an unkeyed physicalwith
> no logicals etc.
-- 
Larry Bolhuis         | What do you want to reload today?
Arbor Solutions, Inc  | 
(616) 451-2500        | Two rules to success in life:
lbolhui@ibm.net       | 1. Never tell people everything you know.
+---
| 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
+---