This is a query from the TSM v6.3 agent:
select node_name, count(distinct volume_name) from volumeusage a, stgpools b where (a.stgpool_name=b.stgpool_name) and devclass in (select DEVCLASS_NAME from devclasses where devtype in ('3570','3590','3592','4MM','8MM','DLT','DTF','ECARTRIDGE','GENERICTAPE','LTO','QIC')) group by node_name
Could you run it on a TSM v5.x.x.x productive system for me!
Do you get any result in 10 minutes?
I ran it on a small (30 nodes) TSM 5.5.2 and it took about 10 secs to get the result.
ReplyDeleteRunning on an ancient P660 RS64-IV setup on TSM 5.5.5.0 the results clocked in as follows:
ReplyDeleteStart: 16:17:15
Stop: 16:21:33
There are around 400 nodes on this server.