ADSM-L

Re: select number of active files and size in MB per node?

2000-05-15 08:52:29
Subject: Re: select number of active files and size in MB per node?
From: Lawrence Clark <Larry_Clark AT THRUWAY.STATE.NY DOT US>
Date: Mon, 15 May 2000 08:52:29 -0400
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
<Prev in Thread] Current Thread [Next in Thread>