This is the EXACT command we could have used about a month ago for our
Disaster Recovery drill. Unfortunately no one at Tivoli support was able
to pass this info on to us.
Maria Paz Gimeno <[EMAIL PROTECTED]>@VM.MARIST.EDU> on 10/02/2000
03:37:27 PM
Please respond to "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]>
Sent by: "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
cc:
Subject: Re: Tapes needed for a restore
These are two selects from previous entries in this forum, the first one is
more specific, the second more simple.
I have not used them, see if they help.
Regards
Maria
select filespace_name,volume_name from volumeusage where node_name='____' -
and copy_type='backup' and stgpool_name='<YourBkupStgpoolName>' group by
volume_name
select node_name,volume_name,stgpool_name from volumeusage where
node_name='$1'
----- Original Message -----
From: Nancy Reeves <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, October 02, 2000 9:10 PM
Subject: Tapes needed for a restore
> Is there a way to query what tapes will be needed for a given restore
> request?
>
> For instance, a user deletes a certain directory and wants to restore it.
> Since most of the files are static and have aged, they have been migrated
> to tape. I would like to make sure all the needed tapes are in the
library
> before starting the restore. Is this possible?
>
> Nancy Reeves
> Technical Support, Wichita State University
> [EMAIL PROTECTED]
