Hi Reinhold:
Sorry, but I do not think that is possible using the occupancy table; it's not
granular to the individual file level, just node.
Regards,
Larry Clark
NYS Thruway Authority
>>> rwagner AT ZEUNASTAERKER DOT DE 05/15/00 10:28AM >>>
Lawrence,
thanks for the answer. I've checked the adsm.org archives twice but didn't find
a fitting answer.
I've tried your select, but it seems to sum active and inactive files. Is there
a possibility
to sum only active files?
TIA
Reinhold Wagner, Zeuna Staerker GmbH & Co. KG
Lawrence Clark <Larry_Clark AT THRUWAY.STATE.NY DOT US> am 15.05.2000 13:52:29
Bitte antworten an "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>
An: ADSM-L AT VM.MARIST DOT EDU
Kopie: (Blindkopie: Reinhold Wagner/A/DE/ZEUNA)
Thema: Re: select number of active files and size in MB per node?
Hi:
This was posted by someone previously:
select node_name, sum(logical_mb) as Data_In_MB, sum(num_files) as Num_of_files
from occupancy group by node_name order by node_name asc
>>> rwagner AT ZEUNASTAERKER DOT DE 05/15/00 05:19AM >>>
Folks,
anyone having a select which shows me the number of active files and the size of
these files
in MB of a certain node?
TIA
Reinhold Wagner, Zeuna Staerker GmbH & Co. KG
|