Richard,
Your approach will work for file data, but a lot of the TDPs don't
accurately register filespace sizes. Only the OP will know what the
impact of that might be in his environment.
I would go for an export allactive preview=yes. It might run for quite
a while.
Regards
Steve
Steven Harris
TSM Admin, Canberra Australia
On 19/07/2011 4:42 AM, Richard Sims wrote:
If your clients are doing unfettered incremental backups of file systems, then
the following would yield a MB approximation, very quickly:
SELECT SUM(CAPACITY*PCT_UTIL/100) FROM FILESPACES
which is based upon TSM's information about the file system as gotten from the
last client operation. By definition, the files on the client represent all
the Active files in TSM storage where the activity is incremental backups.
Richard Sims
