I believe it is show volumeusage...
you have to type out the whole word
-----Original Message-----
From: Nancy Reeves [mailto:[EMAIL PROTECTED]]
Sent: Monday, October 02, 2000 5:47 PM
To: [EMAIL PROTECTED]
Subject: Re: Tapes needed for a restore
Since Kent's preview approach doesn't work for me, and 'show volusage' is
an unknown command, I'm coming to the conclusion that it can't be done
easily with the version I run. (server is ADSM for AIX 3.1.2.1) Although
the crude method suggested of making all tapes unavailable then running a
restore still has potential. An "upgrade" to TSM is in my future.
The "dry run" approach doesn't list the volume label needed, and the
option to skip all objects on this volume is not supported. Oh well.
Thanks for all the suggestions, keep them coming.
Nancy Reeves
Technical Support, Wichita State University
[EMAIL PROTECTED]
<[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
10/02/2000 04:10 PM
To: [EMAIL PROTECTED]
cc:
Subject: Re: Tapes needed for a restore
We have a couple of ways - I prefer (2) - more accurate (prompts for tape
numbers), but takes longer and isn't
implemented in every version of the client 'dsmc' program.
1) Brute-force approach - determine all tapes containing data for that
node/filespace - declare a server script
run from the dsmadmc prompt as:
adsm> run q_tape_recall nodename filespacename
q_tape_recall: select node_name,filespace_name from filespaces -
where node_name=upper('$1') and filespace_name='$2' -
select volumeusage.stgpool_name, date(last_write_date)
as
LAST_WRITE, -
volumeusage.volume_name from volumeusage, volumes -
where volumeusage.node_name=upper('$1') -
and volumeusage.filespace_name='$2' -
and volumeusage.volume_name=volumes.volume_name -
order by volumeusage.stgpool_name, last_write
2) Preview approach - run a dry-run restore, but specify a tempdir target
&
select 'skip all on this tape':
# dsmc> restore -tapeprompt=yes -pick -preservepath=baseonly
<whatever>
<tempdir>
'tapeprompt=Yes|No' is a documented option of the 'dsmc> restore'
client
command.
-fyi
[EMAIL PROTECTED] on 02-Oct-2000 15:10
Please respond to [EMAIL PROTECTED]
To: ADSM-L
cc: (bcc: Kent J Monthei/CIS/PHRD/SB_PLC)
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]
Confidentiality Note: The information transmitted is intended only for the
person or entity to whom or which it is addressed and may contain
confidential and/or privileged material. Any review, retransmission,
dissemination or other use of this information by persons or entities other
than the intended recipient is prohibited. If you receive this in error,
please delete this material immediately.
