Thanks for the responses.  This query should not be per node but per storage
pool.  In a nutshell, I want to determine how much data TSM is managing for
5 TSM servers.  Once I have this query figured out, I will use a script I
created to login to all 5 RS6K SP TSM server nodes and find out the total
storage each one has.

Tonight we are making a drastic change to the number of versions maintained
and after I run expiration, I am going to run the query again to see how
much space we recovered.


--
Joshua S. Bassi
Joshua S. Bassi
Independent IT Consultant
IBM Certified - AIX/HACMP, SAN, Shark
Tivoli Certified Consultant- ADSM/TSM
Cell (408)&(831) 332-4006
jbassi AT ihwy DOT com