On Oct 5, 2004, at 12:20 PM, Fredrik Karlsson wrote:

Hi!

Does anyone have a script to calculate the size of all active data?
Preferably sorted by node.

Kind Regards

Fredrik Karlsson

Fredrik - By definition, Active files are what is currently present in
          the file system, which after a current backup is reflected in
the filespace, such that this macro can quickly compute it:

SELECT NODE_NAME, FILESPACE_NAME, FILESPACE_TYPE, CAPACITY AS "File
System Size in MB", -
 PCT_UTIL, DECIMAL((CAPACITY * (PCT_UTIL / 100.0)), 10, 2) AS "MB of
Active Files" -
 FROM FILESPACES ORDER BY NODE_NAME, FILESPACE_NAME

     Richard Sims     http://people.bu.edu/rbs