SQL Query

[chrisw669]

I want to be able to run a query against the db showing me the node name, number of files and physical space occupied for each client. I can't seem to figure out how to join contents(to get the node name) and occupancy(for the other info). Is this possible? If so, what would the sql query be.

Thanks

 

[chrisw669]

after digging some more, there is a node_name field in the table occupancy. (It's not listed in the ibm redbook). Here's the select statement i used.

select node_name as "Node", sum(num_files) as "Files", sum(physical_mb) as "Usage (MB)" from occupancy group by node_name

 

[gwichman]

send me an email to gwichman@zantaz.com and i'll send you some good documents on using SQL with TSM..