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.


-----Original Message-----
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....


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.
>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
>u2-users mailing list

u2-users mailing list

u2-users mailing list

Reply via email to