ADSM-L

Re: Finding a particular file in a set of volumes

1999-10-14 10:07:26
Subject: Re: Finding a particular file in a set of volumes
From: Bill Colwell <bcolwell AT DRAPER DOT COM>
Date: Thu, 14 Oct 1999 10:07:26 -0400
Larry,

I can think of 2 simple ways.

1, Start the restore or retrieve of the file to a temp directory.  From
an admin client monitor the process.  For example, in dsmadmc enter
q ses f=d.  This will show the volume in use.

2, do an sql select from the volumeusage table using dsmadmc.

select * from volumeusage
 where node_name = 'THE_NODE_IN_QUESTION'
    and filespace_name = 'fs_name_case_matters'
    and type = 'BACKUP|ARCHIVE'

If you are collocating and the node isn't much bigger than the tape capacity
you should get 1 row returned.


--
--------------------------
--------------------------
Bill Colwell
Bill Colwell
C. S. Draper Lab
Cambridge, Ma.
bcolwell AT draper DOT com
--------------------------
In <s805a168.001 AT tagwia.thruway.state.ny DOT us>, on 10/14/99
In <s805a168.001 AT tagwia.thruway.state.ny DOT us>, on 10/14/99
   at 09:24 AM, Lawrence Clark <Larry_Clark AT THRUWAY.STATE.NY DOT US> said:

>Hi:
>Is there a method for finding the volume a particular archived or backed file 
>is on?

>Larry Clark
>NYS Thruway
<Prev in Thread] Current Thread [Next in Thread>