Re: On which volumes are my files?
2003-01-03 13:09:26
Hi Werner
Here's one that shows volumes by filespacename and stgpool name
select distinct node_name,volume_name,stgpool_name from volumeusage
where node_name='$1' and filespace_name='$2' and stgpool_name<>'$3'
Laura Buckley
SSSI/STORServer, Inc.
buckley AT storserver DOT com
-----Original Message-----
From: Werner Baur [mailto:Werner.Baur AT LRZ-MUENCHEN DOT DE]
Sent: 03 January 2003 09:33
To: ADSM-L AT VM.MARIST DOT EDU
Subject: On which volumes are my files?
Does anyone know a fast way to get a list of all volumes on which a node
has files of a specific subdirectory? A query of the volumeusage table
does the job on filespace level but not on file/directory level. The
only way I know is to search in the output of query content or the
corresponding select query which is very slow.
Thanks for any ideas,
Werner
--
Werner Baur Tel.:++49-89-28928781
Leibniz-Rechenzentrum Fax:++49-89-2809460
Barer Str. 21 mailto:baur AT lrz DOT de
D-80333 Muenchen, Germany http://www.lrz.de
|
|
|