TSM command for total size of a node data

[schetan]

Hi there,

I'm new-ish with TSM and I was wondering if there is a command or an sql query that I can use to find out how much data is stored in each of TSM nodes in my main storage pool (ignoring copy pools).

I've been using q nodedata <node_name> but that gives me a breakdown of the data per tape and I need a complete listing of all nodes.

Thanks. Any help is appreciated.

 

[ChrisRees]

Hi

You want something like

select node_name,sum(physical_mb) from occupancy where stgpool_name='<stgpool_name>' group by node_name

or for totals including copy stgpools use

q auditocc

Hope that helps..
Cheers

 

[schetan]

That worked !
You my friend are good !

 

[ChrisRees]

no worries,

let me know if you need any more sql help..

cheers

 

[jssanche]

more useful queries at...

http://www.lascon.co.uk/d005104.htm
http://thobias.org/tsm/sql/index.html