The information in q auditocc tells me a lot but I wonder if there is a way
to get the same information and order it by megabytes/gigabytes/terabytes
from the heaviest hitter to the least. I would also like to have a column
that includes the number of files each of the nodes TSM is tracking. This is
something I would like to have for a meeting to explain:

1.      What it is costing the company to keep this data on tape. I might
also use a moc bill and send it to those people and see their reaction.
2.      What kind of a hit the TSM database takes for nodes it has to track
millions of files.
3.      General reasons to keep our number of versions to what are
necessary, not what someone feels like they need.
4.      Growth expectations and what it will do to our current setup and for
budget considerations next year.



I know I am not kept informed of growth expectations by any of these groups
yet I'm always expected to keep this thing going for nothing. If anyone has
a query that can provide these things could you please share it? You could
say I am the worst at sql statements and I would not argue one bit. I'm sure
others in the group could also benefit by it.



Thanks for the help,

And if you can think of something else I might include that would be helpful
please feel free.

Geoff Gill
TSM Administrator
NT Systems Support Engineer
SAIC
E-Mail:   gillg AT saic DOT com
Phone:  (858) 826-4062
Pager:   (877) 905-7154