Here is the script I use. You run it with 3 parameters:
- node name
- (first characters of) storage pool name
- (substring of) filespace name
For the second and third parameters you may also give the empty string "" as
parameter to query all stg pools/filespaces.
SELECT DISTINCT -
CAST(volumeusage.volume_name AS CHAR(6)) as "Volume", -
volumeusage.stgpool_name as "STGPOOL", -
CAST(volumes.est_capacity_mb as decimal(6,0)) as "Capacity",
CAST(volumes.pct_utilized AS DECIMAL(4,1)) AS "% used", -
CAST(volumes.status AS CHAR(7)) as "Status", -
CAST(volumes.access AS CHAR(6)) as "Access", -
DATE(volumes.last_write_date) as "Last write" -
FROM volumeusage,volumes -
WHERE volumeusage.node_name=upper('$1') -
AND volumeusage.stgpool_name like upper('$2' || '%') -
AND volumeusage.filespace_name like ('%' || '$3' || '%') -
AND volumeusage.volume_name=volumes.volume_name -
ORDER BY 1
Rainer Schöpf
--------------------------------------------------------------------------
On Fri, 22 Aug 2008, Pavel Sitnikov wrote:
> Anybody know command for find particular filespace volume on the library?
> Q FILES NODE_NAME F=D and Q CON is not good idea in this case. And I know
> what it is done with Web client.
> I want to know on what volume resides filespace.
> I appreciate any help!
>
> ..............................................................
> С уважением, Ситников Павел
> Дирекция сопровождения серверных систем
> ОАО "УРАЛСИБ", Уфа
> (347) 251-96-62, (010) 4385
>
--------------------------------------------------------
ProteoSys AG
Carl-Zeiss-Straße 51
55129 Mainz
Dr. Rainer Schöpf
Leiter Software/Softwareentwicklung
Mail: rainer.schoepf AT proteosys DOT com
Phone: +49-(0)6131-50192-41
Fax: +49-(0)6131-50192-11
WWW: http://www.proteosys.com/
--------------------------------------------------------
ProteoSys AG - Carl-Zeiss-Str. 51 - D-55129 Mainz
Amtsgericht Mainz HRB 7508 - USt.-Id Nr.: DE213940570
Vorstand: Helmut Matthies (Vorsitzender), Prof. Dr. André Schrattenholz
Vorsitzender des Aufsichtsrates: Dr. Werner Zöllner
|