There is a file_size column in the contents table.  Unfortunately this
reports the size of the aggregate, not the individual file, except when
the file is very large and thus not aggregated (greater than the client
txnbytes setting). Also the contents table is a dog to query, so it is
useless in a large system.

(Remember that I asked about putting the database in db2/oracle?  I would
expect all columns to be defined and sql selectable if the db were in a
standard dbms.)

--
--------------------------
--------------------------
Bill Colwell
Bill Colwell
C. S. Draper Lab
Cambridge, Ma.
bcolwell AT draper DOT com
--------------------------
In <200001261840.NAA64562 AT fserv2.bu DOT edu>, on 01/26/00
In <200001261840.NAA64562 AT fserv2.bu DOT edu>, on 01/26/00
   at 05:16 PM, Richard Sims <rbs AT BU DOT EDU> said:

>I've been looking into SQL for some means of reporting Backup and Archive
>files, but there seems to be no way to report file attributes such as
>file size, last accessed datestamp, last modified timestamp, etc. Is this
>information actually unavailable via SQL, or can someone give an example
>of the means of displaying that info?
>   thanks,  Richard Sims, BU