Re: [ADSM-L] Select statement for client occupancy by management class...???
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
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
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.
> 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