Mail Archive Search: <+subject:/^(?:^\s*(re|sv|fwd|fw)[\[\]\d]*[:>-]+\s*)*\[ADSM\-L\]\s+Select\s+statement\s+for\s+client\s+occupancy\s+by\s+management\s+class\.\.\.\?\?\?\s*$/>

Results:

References: [ +subject:/^(?:^\s*(re|sv|fwd|fw)[\[\]\d]*[:>-]+\s*)*\[ADSM\-L\]\s+Select\s+statement\s+for\s+client\s+occupancy\s+by\s+management\s+class\.\.\.\?\?\?\s*$/: 3 ]

Total 3 documents matching your query.

1. [ADSM-L] Select statement for client occupancy by management class...??? (score: 1): Author: Dwight Cook <cookde AT US.IBM DOT COM>; Date: Mon, 11 Apr 2016 07:43:05 -0500; 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; /usr/local/webapp/mharc-adsm.org/html/ADSM-L/2016-04/msg00032.html (10,092 bytes)
2. Re: [ADSM-L] Select statement for client occupancy by management class...??? (score: 1): Author: Efim <aefim771 AT GMAIL DOT COM>; Date: Mon, 11 Apr 2016 16:19:53 +0300; 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 dont have s; /usr/local/webapp/mharc-adsm.org/html/ADSM-L/2016-04/msg00033.html (10,971 bytes)
3. Re: [ADSM-L] Select statement for client occupancy by management class...??? (score: 1): Author: Dwight Cook <cookde AT US.IBM DOT COM>; Date: Mon, 11 Apr 2016 09:59:41 -0500; 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.cla; /usr/local/webapp/mharc-adsm.org/html/ADSM-L/2016-04/msg00035.html (12,053 bytes)

Current List: 1 - 3
Page: [1]