What does the 'Physical File Open accesses' displayed in the DSPFD command
Does it really show the number of times this file was opened?
I am seeing pretty high numbers in one file (40000/min) but no one has
complained of degradation in performance of that file, and I can't really
believe that file is opened that frequently. The code is supposed to be
extremely fine tuned with no program in the call stack opening/closing
files. The ODP in batch jobs I have checked is constant.
Also, for that file 'Physical File Close accesses' is HIGHER than Open
This mailing list archive is Copyright 1997-2019 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact