TSMers, I was thinking about trying to write a select that would let me compare a clients known filespace usage (q file) with the amount of TSM backup storage used by the client (q occ). Such a select could give us a % number that we could use to estimate a clients storage needs before it is actually registered and backed up. Of course the % would be highly dependent upon policies, etc. but would be a good starting point for clients using our standard policy set and management classes.
Not wanting to unnecessarily beat myself up, have any of you written such a select and would you be willing to share your code and/or ideas? -- Steve Bennett, (907) 465-5783 State of Alaska, Information Technology Group, Technical Services Section