with a side-note that this figure includes data that may be excluded from
backup. As long as you don't exclude too much, that would be ok. If you have
many databases, and/or long exclude lists YMMV.
On 18 jul 2011, at 20:42, 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
Met vriendelijke groeten/Kind Regards,
r.post AT plcs DOT nl
+31 6 248 21 622