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
