Richard Sims schrieb:
A very obvious but conspicuously missing option from client restores is
a Preview capability, which would nicely address this restoral planning
need that has historically been the subject of so many postings.
When you think about it, it's rather amazing that the product has u
27;s password. I've done
it many times myself.
Zlatko Krastev
IT Consultant
Richard Sims <[EMAIL PROTECTED]>
Sent by: "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]>
03.01.2003 14:33
Please respond to "ADSM: Dist Stor Manager"
To: [EMAIL PROTE
>Although I agree perfectly that your approach would be much faster it is
>not feasible in this case:
>The reason behind the original question was to get in advance a list of
>offsite tapes which have to be checked in for a file or directory
>restore operation before starting the restore itself. If
Richard Sims wrote:
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 th
Oops -
Correction to my last post. I took my select from a script I wrote
trying to find volumes that weren't in certain pools. Here's what I
really meant
select distinct volume_name,stgpool_name from volumeusage where
node_name='$1' and filespace_name='$2' and stgpool_name='$3'
Laura
-O
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.
[EMAIL PROTECTED]
-Original Message-
Fro
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 quer
I use this kind of script ... It works
$1 node name
$2 name of pool
select
volumeusage.volume_name,volumes.access,volumes.error_state,volumeusage.stgpool_name
from volumeusage,volumes where volumeusage.node_name=upper('$1')and
volumeusage.stgpool_name='$2' and volumeusage.volume_name =
volumes.vo
>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
Hi
I generally use the following select statement, however if there is an
easier way please let me know.
select distinct node_name,volume_name,stgpool_name from volumeusage where
node_name='nodename' and stgpool_name='storage pool'
Lawrie
-Original Message-
From: Werner Baur [mailto:[E
10 matches
Mail list logo
