correct that IF statistics collection HAS been enabled, yet the file has NEVER been closed, thus no header updates have occurred.....
Ok. Tried this. Statistics collection can definitely be determined using the FILE.USAGE command. If they are enabled, the listing will also include a line such as:
Statistics last reset <timestamp>
(Statistics last reset Thu Nov 18 17:06:33 2004)
IF this line does NOT appear, statistics collection is definitely OFF.
At 04:22 PM 11/18/2004, you wrote:
I don't think that's correct. I did some tests on this several years ago. If memory serves, when file usage is ON, counts are held in memory. They don't actually get written to the file header on disk until the file is closed.
Or am I mis-remembering again?
--
Regards,
Clif
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ W. Clifton Oliver, CCP CLIFTON OLIVER & ASSOCIATES Tel: +1 619 460 5678 Web: www.oliver.com ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Glenn Herbert wrote:
I believe if you run FILE.USAGE <filename> and all values are zero, then statistic collection is OFF. You enable it using FILE.USAGE.CLEAR; disable it using FILE.USAGE.OFF.
At 02:54 PM 11/18/2004, you wrote:
Is there a way to tell if FILE.USAGE has been set to collect information? -Dianne------- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
------- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
