Re: [U2] RE: [UV] Monitoring file changes
Thanks! That helped. -Dianne Glenn Herbert wrote: Yeah. I said that in a previous email. The question was simply is there a way to determine if statistics are enabled and, without having to delve into the file header, listing out the statistics using FILE.USAGE is the only way to tell. Of course, you are 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 (Statistics last reset Thu Nov 18 17:06:33 2004) IF this line does NOT appear, statistics collection is definitely OFF. --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] RE: [UV] Monitoring file changes
At 06:40 PM 11/18/2004, you wrote: [snipped] If person A has the file open and person B does a list, is the updated information writen when person B ends her list? Or when person A finally closes the file? In other words, is the header information viewable, even though someone somewhere is still holding the file open? Will The information is updated in the file header whenever ANY close operation is done (well, this does assume you have statistics collection ON!). Thus, if A and B both have the file open having started at the same time, but A finishes first, so A locks the file and adds its totals to the existing totals in the file header, then unlocks it, then when B completes its use of the file, B gets the lock on the file and then adds ITS totals to the existing totals. Remember, the file is a concurrent use file such that many processes can have the file open and read from it, but only a SINGLE process can write to any particular portion (group) of the file at a time, which includes the header (group 0). Make sense? --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
Unclassified RE: [U2] RE: [UV] Monitoring file changes
But unfortunately none of this FILE.USAGE stuff will work for the original poster because his file is DYNAMIC, and FILE.USAGE doesn't support DYNAMIC files, e.g. >FILE.USAGE A.DYNAMIC.FILE Cannot process type 1, 19, 25 or 30 file "". > And since he's on UV 9.6.2, he can't use Triggers, either. Hmmm -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Mike Pflugfelder Sent: Thursday, 18 November 2004 04:12 To: u2-users Subject: [U2] Monitoring file changes [snip] Universe 9.6.2.1 Dec OSF1 V4.0F [snip] I'm not sure if it will help, but I'm including an ANALYZE.FILE EMPMAST STATS: File name .. EMPMAST Pathname ... EMPMAST File type .. DYNAMIC [snip] The information contained in this Internet Email message is intended for the addressee only and may contain privileged information, but not necessarily the official views or opinions of the New Zealand Defence Force. If you are not the intended recipient you must not use, disclose, copy or distribute this message or the information in it. If you have received this message in error, please Email or telephone the sender immediately. --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] RE: [UV] Monitoring file changes
LIST is doing a read-only access. It will update the header with the read accesses when the list either finishes or is terminated. Otherwise, nobody would be able to update the header unless everybody closes the file at some point. You could even write data to the file and it would update as soon as your program finishes. It's only the file header locking that would get in the way but those are so fast that you'll never notice a delay. Bob Woodward Programmer/Analyst Harbor Wholesale Grocery [EMAIL PROTECTED] > -Original Message- > From: [EMAIL PROTECTED] [mailto:owner-u2- > [EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] > Sent: Thursday, November 18, 2004 3:41 PM > To: [EMAIL PROTECTED] > Subject: RE: [U2] RE: [UV] Monitoring file changes > > In a message dated 11/18/2004 5:25:03 PM Eastern Standard Time, "Bob > Woodward" <[EMAIL PROTECTED]> writes: > > >If the file has never been closed, just do a quick LIST on the file. If > >FILE.USAGE is on then when you end the list, you'll at LEAST get some > >read hits on it. > > > >Bob Woodward > > If person A has the file open and person B does a list, is the updated > information writen when person B ends her list? Or when person A finally > closes the file? In other words, is the header information viewable, even > though someone somewhere is still holding the file open? > Will > > > >> -Original Message- > >> From: [EMAIL PROTECTED] [mailto:owner-u2- > >> [EMAIL PROTECTED] On Behalf Of Glenn Herbert > >> Sent: Thursday, November 18, 2004 2:04 PM > >> To: [EMAIL PROTECTED] > >> Subject: Re: [U2] RE: [UV] Monitoring file changes > >> > >> Yeah. I said that in a previous email. The question was simply is > >there a > >> way to determine if statistics are enabled and, without having to > >delve > >> into the file header, listing out the statistics using FILE.USAGE is > >the > >> only way to tell. Of course, you are > >> 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 > >> > >> (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 5678Web: www.oliver.com > >> >~~~ > >> > > >> > > >> >Glenn Herbert wrote: > >> > > >> >>I believe if you run FILE.USAGE 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/ > >--- > >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/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] RE: [UV] Monitoring file changes
In a message dated 11/18/2004 5:25:03 PM Eastern Standard Time, "Bob Woodward" <[EMAIL PROTECTED]> writes: >If the file has never been closed, just do a quick LIST on the file. If >FILE.USAGE is on then when you end the list, you'll at LEAST get some >read hits on it. > >Bob Woodward If person A has the file open and person B does a list, is the updated information writen when person B ends her list? Or when person A finally closes the file? In other words, is the header information viewable, even though someone somewhere is still holding the file open? Will >> -Original Message- >> From: [EMAIL PROTECTED] [mailto:owner-u2- >> [EMAIL PROTECTED] On Behalf Of Glenn Herbert >> Sent: Thursday, November 18, 2004 2:04 PM >> To: [EMAIL PROTECTED] >> Subject: Re: [U2] RE: [UV] Monitoring file changes >> >> Yeah. I said that in a previous email. The question was simply is >there a >> way to determine if statistics are enabled and, without having to >delve >> into the file header, listing out the statistics using FILE.USAGE is >the >> only way to tell. Of course, you are >> 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 >> >> (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 5678Web: www.oliver.com >> >~~~ >> > >> > >> >Glenn Herbert wrote: >> > >> >>I believe if you run FILE.USAGE 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/ >--- >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/
Re: [U2] RE: [UV] Monitoring file changes
Comments and responses embedded in the text below. Glenn Herbert wrote: Yeah. I said that in a previous email. Oops. Missed that one. The perils of speed-reading. 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 (Statistics last reset Thu Nov 18 17:06:33 2004) IF this line does NOT appear, statistics collection is definitely OFF. Very useful. Thanks! -- Regards, Clif ~~~ W. Clifton Oliver, CCP CLIFTON OLIVER & ASSOCIATES Tel: +1 619 460 5678Web: www.oliver.com ~~~ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] RE: [UV] Monitoring file changes
If the file has never been closed, just do a quick LIST on the file. If FILE.USAGE is on then when you end the list, you'll at LEAST get some read hits on it. Bob Woodward Programmer/Analyst Harbor Wholesale Grocery [EMAIL PROTECTED] > -Original Message- > From: [EMAIL PROTECTED] [mailto:owner-u2- > [EMAIL PROTECTED] On Behalf Of Glenn Herbert > Sent: Thursday, November 18, 2004 2:04 PM > To: [EMAIL PROTECTED] > Subject: Re: [U2] RE: [UV] Monitoring file changes > > Yeah. I said that in a previous email. The question was simply is there a > way to determine if statistics are enabled and, without having to delve > into the file header, listing out the statistics using FILE.USAGE is the > only way to tell. Of course, you are > 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 > > (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 5678Web: www.oliver.com > >~~~ > > > > > >Glenn Herbert wrote: > > > >>I believe if you run FILE.USAGE 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/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] RE: [UV] Monitoring file changes
Yeah. I said that in a previous email. The question was simply is there a way to determine if statistics are enabled and, without having to delve into the file header, listing out the statistics using FILE.USAGE is the only way to tell. Of course, you are 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 (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 5678Web: www.oliver.com ~~~ Glenn Herbert wrote: I believe if you run FILE.USAGE 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/
Re: [U2] RE: [UV] Monitoring file changes
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 5678Web: www.oliver.com ~~~ Glenn Herbert wrote: I believe if you run FILE.USAGE 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/
Re: [U2] RE: [UV] Monitoring file changes
I believe if you run FILE.USAGE 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 [EMAIL PROTECTED] wrote: I've never used FILE.USAGE. Where can I find out more information such as where the information is stored, is there much of a performance hit while using it, etc... Thanks -- Original message -- You can certainly collect statistics on the number of writes, deletes, clear-files, etc., using the FILE.USAGE group of commands. FILE.USAGE.CLEAR to reset statistics and enable collection FILE.USAGE.OFF to disable further collection FILE.USAGE to view statistics This does not identify the culprit. However, we once used it to prove that a file was being cleared (by a rogue ex-employee, as it turned out, who was successfully prosecuted) even though the owners of the application swore blind (and could prove) that nowhere in the application was the file cleared. --- 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/
Re: [U2] RE: [UV] Monitoring file changes
Is there a way to tell if FILE.USAGE has been set to collect information? -Dianne [EMAIL PROTECTED] wrote: I've never used FILE.USAGE. Where can I find out more information such as where the information is stored, is there much of a performance hit while using it, etc... Thanks -- Original message -- You can certainly collect statistics on the number of writes, deletes, clear-files, etc., using the FILE.USAGE group of commands. FILE.USAGE.CLEAR to reset statistics and enable collection FILE.USAGE.OFF to disable further collection FILE.USAGE to view statistics This does not identify the culprit. However, we once used it to prove that a file was being cleared (by a rogue ex-employee, as it turned out, who was successfully prosecuted) even though the owners of the application swore blind (and could prove) that nowhere in the application was the file cleared. --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] RE: [UV] Monitoring file changes
Thanks a bunch Glenn -- Original message -- > The information is stored IN the file header (see the Stats region if you > have access to the internal file documentation). And the performance hit > comes when you close the file and all the numbers you collected over time > (in memory) is added to the header values, which means you lock down the > ENTIRE file (group 0) during that time. It's not meant to be kept on for > long periods of time. > > At 12:59 PM 11/18/2004, you wrote: > >I've never used FILE.USAGE. Where can I find out more information such as > >where the information is stored, is there much of a performance hit while > >using it, etc... > > > >Thanks > > > >-- Original message -- > > > > > You can certainly collect statistics on the number of writes, deletes, > > > clear-files, etc., using the FILE.USAGE group of commands. > > > FILE.USAGE.CLEAR to reset statistics and enable collection > > > FILE.USAGE.OFF to disable further collection > > > FILE.USAGE to view statistics > > > > > > This does not identify the culprit. However, we once used it to prove > > that a > > > file was being cleared (by a rogue ex-employee, as it turned out, who was > > > successfully prosecuted) even though the owners of the application > > swore blind > > > (and could prove) that nowhere in the application was the file cleared. > > > --- > > > 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/ > --- > 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/
Re: [U2] RE: [UV] Monitoring file changes
The information is stored IN the file header (see the Stats region if you have access to the internal file documentation). And the performance hit comes when you close the file and all the numbers you collected over time (in memory) is added to the header values, which means you lock down the ENTIRE file (group 0) during that time. It's not meant to be kept on for long periods of time. At 12:59 PM 11/18/2004, you wrote: I've never used FILE.USAGE. Where can I find out more information such as where the information is stored, is there much of a performance hit while using it, etc... Thanks -- Original message -- > You can certainly collect statistics on the number of writes, deletes, > clear-files, etc., using the FILE.USAGE group of commands. > FILE.USAGE.CLEAR to reset statistics and enable collection > FILE.USAGE.OFF to disable further collection > FILE.USAGE to view statistics > > This does not identify the culprit. However, we once used it to prove that a > file was being cleared (by a rogue ex-employee, as it turned out, who was > successfully prosecuted) even though the owners of the application swore blind > (and could prove) that nowhere in the application was the file cleared. > --- > 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/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] RE: [UV] Monitoring file changes
I've never used FILE.USAGE. Where can I find out more information such as where the information is stored, is there much of a performance hit while using it, etc... Thanks -- Original message -- > You can certainly collect statistics on the number of writes, deletes, > clear-files, etc., using the FILE.USAGE group of commands. > FILE.USAGE.CLEAR to reset statistics and enable collection > FILE.USAGE.OFF to disable further collection > FILE.USAGE to view statistics > > This does not identify the culprit. However, we once used it to prove that a > file was being cleared (by a rogue ex-employee, as it turned out, who was > successfully prosecuted) even though the owners of the application swore > blind > (and could prove) that nowhere in the application was the file cleared. > --- > 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/