select b.node_name,b.class_name,sum(c.file_size) from backups b,contents c 
where b.object_id=c.object_id and b.node_name and b.node_name in 
('<node1>','<node2>','<node-n>')  group by b.node_name,b.class_name

(don't expect it to run fast though...)


Dwight E. Cook
Technical Services Prof. Sr. 
TSM Delivery Architect
IBM Cloud
(918) 493-4678



From:   Efim <aefim771 AT GMAIL DOT COM>
To:     ADSM-L AT VM.MARIST DOT EDU
Date:   04/11/2016 08:20 AM
Subject:        Re: Select statement for client occupancy by management 
class...???
Sent by:        "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>



Do you use different storage pools for each management class?
If no - it is very very difficult to calculate occupancy for each stored 
object because you must select from backups table.
I don?t have select for do it.

Efim


> 11 апр. 2016 г., в 15:43, Dwight Cook <cookde AT US.IBM DOT COM> написал(а):
> 
> Does anyone have a select statement for client occupancy by management 
> class (so I don't have to recreate the wheel)?
> 
> 
> Dwight E. Cook
> Technical Services Prof. Sr. 
> TSM Delivery Architect
> IBM Cloud
> (918) 493-4678