RE: COUNT modifying unix timestamp
Is there any way to directly access information stored in the file header? I use the information returned by the FILE.USAGE command to determine if a static file can be archived or if it needs to be checked to see if it needs to be resized. Vance -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Glenn Herbert Sent: Tuesday, February 17, 2004 9:18 AM To: U2 Users Discussion List; U2 Users Discussion List Subject: Re: COUNT modifying unix timestamp Actually, it was added in during release 7.x of uniVerse to support the SQL optimizer. The optimizer used the count to make a determination on how long it would take to perform certain SQL operations such as outer-joins, etc, and spit out a warning message something like It will take 4307 hours to perform this operation. Do you want to continue?. At first, only an unqualified COUNT command (i.e. COUNT FILE) would update this field, but sometime in early 8.x releases, I added the code into uvbackup/uvrestore so that it would also update this field. That was quite a few years ago so I don't have the exact timeframes, but there ya go Glenn At 04:54 AM 02/17/2004, Martin Phillips wrote: Apologies if I missed anyone already giving this explanation... The other thing, of course, which timestamp? Date modified, or date accessed? Are you sure your client isn't looking at the wrong one? UniVerse file system revision 12 which came in at release 9.5 includes a count of records in the file header for use by uvbackup and uvrestore. This is updated by COUNT and by uvbackup itself (perhaps other places too). Maybe it's time for another plug for the UniVerse Internals course where these things get discussed??? Martin Phillips Ladybridge Systems 17b Coldstream Lane, Hardingstone, Northampton NN4 6DB +44-(0)1604-709200 -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: COUNT modifying unix timestamp
I believe there is. There is a UNIVERSE.INCLUDE file FILEINFO.H which includes a definition of what would be in each dynamic array field when using: FILEINFO(Fvar, 99) or FILEINFO(Fvar, FINFO$HDRLAYOUT) For example if you executed: FileInfo = FILEINFO(Fvar, 99) you'd have: FileInfo1 = File revision level FileInfo2 = Modulus FileInfo3 = Separation etc etc etc The count field updated in the file header would be FileInfo112. Note that some fields are bitmapped and none of that is detailed. Each of the fields makes more sense if you know what actually exists within a universe file header. I know there is documentation out there ;-) At 02:11 PM 02/18/2004, you wrote: Is there any way to directly access information stored in the file header? I use the information returned by the FILE.USAGE command to determine if a static file can be archived or if it needs to be checked to see if it needs to be resized. Vance -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Glenn Herbert Sent: Tuesday, February 17, 2004 9:18 AM To: U2 Users Discussion List; U2 Users Discussion List Subject: Re: COUNT modifying unix timestamp Actually, it was added in during release 7.x of uniVerse to support the SQL optimizer. The optimizer used the count to make a determination on how long it would take to perform certain SQL operations such as outer-joins, etc, and spit out a warning message something like It will take 4307 hours to perform this operation. Do you want to continue?. At first, only an unqualified COUNT command (i.e. COUNT FILE) would update this field, but sometime in early 8.x releases, I added the code into uvbackup/uvrestore so that it would also update this field. That was quite a few years ago so I don't have the exact timeframes, but there ya go Glenn At 04:54 AM 02/17/2004, Martin Phillips wrote: Apologies if I missed anyone already giving this explanation... The other thing, of course, which timestamp? Date modified, or date accessed? Are you sure your client isn't looking at the wrong one? UniVerse file system revision 12 which came in at release 9.5 includes a count of records in the file header for use by uvbackup and uvrestore. This is updated by COUNT and by uvbackup itself (perhaps other places too). Maybe it's time for another plug for the UniVerse Internals course where these things get discussed??? Martin Phillips Ladybridge Systems 17b Coldstream Lane, Hardingstone, Northampton NN4 6DB +44-(0)1604-709200 -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: COUNT modifying unix timestamp
Cool. I found the include file with the following comment: * 04/23/99 24742 GMH Add special FINFO$HDRLAYOUT and access keywords ;-) But my include file only includes keys up to the following line: EQUATE FH$RESIZEPATH TO 95 I am running 9.6. Were the extra keys added in a later release or do I just need to search for additional documentation? Vance -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Glenn Herbert Sent: Wednesday, February 18, 2004 2:28 PM To: U2 Users Discussion List Subject: RE: COUNT modifying unix timestamp I believe there is. There is a UNIVERSE.INCLUDE file FILEINFO.H which includes a definition of what would be in each dynamic array field when using: FILEINFO(Fvar, 99) or FILEINFO(Fvar, FINFO$HDRLAYOUT) For example if you executed: FileInfo = FILEINFO(Fvar, 99) you'd have: FileInfo1 = File revision level FileInfo2 = Modulus FileInfo3 = Separation etc etc etc The count field updated in the file header would be FileInfo112. Note that some fields are bitmapped and none of that is detailed. Each of the fields makes more sense if you know what actually exists within a universe file header. I know there is documentation out there ;-) At 02:11 PM 02/18/2004, you wrote: Is there any way to directly access information stored in the file header? I use the information returned by the FILE.USAGE command to determine if a static file can be archived or if it needs to be checked to see if it needs to be resized. Vance -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: COUNT modifying unix timestamp
Actually, it was added in during release 7.x of uniVerse to support the SQL optimizer. The optimizer used the count to make a determination on how long it would take to perform certain SQL operations such as outer-joins, etc, and spit out a warning message something like It will take 4307 hours to perform this operation. Do you want to continue?. At first, only an unqualified COUNT command (i.e. COUNT FILE) would update this field, but sometime in early 8.x releases, I added the code into uvbackup/uvrestore so that it would also update this field. That was quite a few years ago so I don't have the exact timeframes, but there ya go Glenn At 04:54 AM 02/17/2004, Martin Phillips wrote: Apologies if I missed anyone already giving this explanation... The other thing, of course, which timestamp? Date modified, or date accessed? Are you sure your client isn't looking at the wrong one? UniVerse file system revision 12 which came in at release 9.5 includes a count of records in the file header for use by uvbackup and uvrestore. This is updated by COUNT and by uvbackup itself (perhaps other places too). Maybe it's time for another plug for the UniVerse Internals course where these things get discussed??? Martin Phillips Ladybridge Systems 17b Coldstream Lane, Hardingstone, Northampton NN4 6DB +44-(0)1604-709200 -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: COUNT modifying unix timestamp
You don't mention the file type, but I am assuming it is a dynamic file. If it is, this is normal. I recall the first release of reliable dynamic files had the feature of disallowing access to users without 'read and write' permission...which wasn't actually documented anywhere...ouch! I think you will find 'LIST' and other 'read-only' commands has the same effect. Regards, David -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Eves, David Sent: Tuesday, February 17, 2004 9:40 AM To: U2 Users Discussion List Subject: COUNT modifying unix timestamp We have a client running UV 10.0.16 on HPUX 11i who has noted that a Universe COUNT will modify the unix timestamp of a file. Has this always been the case? Why does a supposedly read-only operation like COUNT modify the timestamp but others such as LIST, SORT, etc. don't? Cheers, David Eves -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
unclassified RE: COUNT modifying Unix timestamp
David, I see the same effect on UV 10.0.15 on Win2K3 for Dynamic files, also for Dictionaries (type 3). LIST a file: no change to Windows file timestamp. COUNT the same file: Windows file timestamp is updated. ! Mike -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Eves, David Sent: Tuesday, February 17, 2004 9:40 AM To: U2 Users Discussion List Subject: COUNT modifying Unix timestamp We have a client running UV 10.0.16 on HPUX 11i who has noted that a Universe COUNT will modify the Unix timestamp of a file. Has this always been the case? Why does a supposedly read-only operation like COUNT modify the timestamp but others such as LIST, SORT, etc. don't? Cheers, David Eves 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] http://www.oliver.com/mailman/listinfo/u2-users