Kolbeinn,
Nice query - the output of the query below can get confusing when you
have copy storage pools and send data offsite - here's a modification
which I've found useful:
select VOLUME_NAME, ACCESS, STATUS- PCT_UTILIZED, STGPOOL_NAME
from VOLUMES
where (select POOLTYPE from STGPOOLS where VOLUMES.STGPOOL_NAME
= STGPOOLS.STGPOOL_NAME) = 'PRIMARY'
and VOLUME_NAME in (select VOLUME_NAME from VOLUMEUSAGE where
NODE_NAME = 'NODEXYZ')
which narrows the query down to just those tapes which are onsite. You
can substitute 'PRIMARY' for 'COPY' if you want to see the copystgpool
(offsite in our env) tapes.
Rgds,
David McClelland
Reuters Ltd., London
-----Original Message-----
From: Kolbeinn Josepsson [mailto:[EMAIL PROTECTED]
Sent: 20 February 2004 14:03
To: [EMAIL PROTECTED]
Subject: Re: Querying What tapes you need for a restore?
select volume_name, access, status, pct_utilized from volumes where
volume_name in (select volume_name from volumeusage where
node_name='YOUR_NODE_NAME')
Best regards,
Kolbeinn Josepsson * Systems Engineer
Tivoli Certified Consultant - IBM Tivoli Storage Manager V5.1 IBM
Certified Deployment Professional - Tivoli Storage Resource Manager
V1.2
Tel: +354 569-7700 * Fax: +354 569-7799
www.nyherji.is
Andrew Raibeck <[EMAIL PROTECTED]>
Sent by: "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]> 20.02.2004
05:35 Please respond to
"ADSM: Dist Stor Manager" <[EMAIL PROTECTED]>
To
[EMAIL PROTECTED]
cc
Subject
Re: Querying What tapes you need for a restore?
No, there is no function like this in TSM. However, a compromise
solution would be to run a SELECT statement against the VOLUMEUSAGE
table to determine which volumes contain data for a particular node. You
can also filter on file space name and copy type (backup or
archive).This will most likely give you a superset of the tapes, so
you'd be checking in more than you need... as I said, it's a compromise.
Regards,
Andy
Andy Raibeck
IBM Software Group
Tivoli Storage Manager Client Development
Internal Notes e-mail: Andrew Raibeck/Tucson/[EMAIL PROTECTED]
Internet e-mail: [EMAIL PROTECTED]
The only dumb question is the one that goes unasked.
The command line is your friend.
"Good enough" is the enemy of excellence.
Gerald Wichmann <[EMAIL PROTECTED]>
Sent by: "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]> 02/19/2004
15:26 Please respond to
"ADSM: Dist Stor Manager"
To
[EMAIL PROTECTED]
cc
Subject
Querying What tapes you need for a restore?
Is there a way to query a list of tapes needed for a given restore prior
to doing the restore such that you can ensure all those tapes are in
your library prior to kicking off the restore? I think the normal mode
of operation is if you were to do a restore that involved several tapes
and some tapes were in your library and some were not, it would move
along fine with those tapes it has but the restore would halt and issue
a mount request for those that aren't in the library. I'd like to avoid
that mount request and just ensure all the tapes are in the library
beforehand.
Gerald
This e-mail has been captured and archived by the ZANTAZ Digital
Safe(tm) service. For more information, visit us at www.zantaz.com.
IMPORTANT: This electronic mail message is intended only for the use of
the individual or entity to which it is addressed and may contain
information that is privileged, confidential or exempt from disclosure
under applicable law. If the reader of this message is not the intended
recipient, or the employee or agent responsible for delivering this
message to the intended recipient, you are hereby notified that any
dissemination, distribution or copying of this communication is strictly
prohibited. If you have received this communication in error, please
notify the sender immediately by telephone or directly reply to the
original message(s) sent. Thank you.
-------------------------------------------------------------- --
Visit our Internet site at http://www.reuters.com
Get closer to the financial markets with Reuters Messaging - for more
information and to register, visit http://www.reuters.com/messaging
Any views expressed in this message are those of the individual
sender, except where the sender specifically states them to be
the views of Reuters Ltd.
