Hello,

I was wondering if anyone has a good definition of the CAPACITY value in the
FILESPACES table. On the export from the DB all it has for a definition is
"Capacity (MB)". I have been experimenting with this value in hopes of
finding a way to measure how much disk space is in use, for example select
SUM(CAPACITY * PCT_UTIL/100) form FILESPACES. However, this gives unexpected
results on some systems. On one TSM server this reports 9000 TB. When I put
a time range on the query, the results change. On the server that reported
9000TB unbounded, it reports 4GB with a 24 hour time range.

My overall goal is to computer a Tape Occupancy / Used Disk Space ratio for
reporting. Perhaps there is a better way to do this?

Thanks in advance,

Al Bratlie
Lead Systems Engineer
Enterprise Storage Group
Thomson Legal and Regulatory Group Technical Services

"All views and opinions expressed are those of the author and have not been
approved or reviewed by TLRTS"