Re: select statement

Hi,

Unless I misunderstand your question you are
asking for three separate lists so I think
the only way to do it is using three sql queries.

Something like this perhaps:

select node_name from nodes

select node_name -
as "Node name", -
filespace_name as "File space name", -
sum(physical_mb) as "MB's" -
from occupancy -
group by node_name,filespace_name

select node_name -
as "Node name", -
sum(physical_mb) as "MB's" -
from occupancy -
group by node_name

Please note that these queries will list *all*
your nodes. Depending on how many nodes you
have registered the resulting lists may be
quit long.
And also note that the amount of data reported
is the sum of all data on all storage pools
for that node/filespace, including copy pools.
You may or may not want this.
We usually prefer to know only the amount of
data that is stored in the primary pools because
we use that number for creating invoices.

I hope this helps.

Kind regards,

Alexander

------------------------------------------------------------
Alexander Verkooijen
Alexander Verkooijen
Senior Systems Programmer
High Performance Computing
SARA Computing & Networking Services


> -----Original Message-----
> From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] 
> On Behalf Of Joni Moyer
> Sent: donderdag 2 september 2004 13:55
> To: ADSM-L AT VM.MARIST DOT EDU
> Subject: select statement - filespaces
> 
> 
> Hello all!
> 
> I was just wondering if there is any way to list each node, each
> filespace/node, size & amount used and then total each 
> individual node's
> size (space used only).  Is  such a select statement 
> possible?  Thanks!
> 
> ********************************
> Joni Moyer
> Highmark
> Storage Systems
> Work:(717)302-6603
> Fax:(717)302-5974
> joni.moyer AT highmark DOT com
> ********************************
>
Re: select statement - filespaces
