Re: Querying What tapes you need for a restore?

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:Kolbeinn.Josepsson AT NYHERJI DOT IS] 
Sent: 20 February 2004 14:03
To: ADSM-L AT VM.MARIST DOT EDU
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 <storman AT US.IBM DOT COM> 
Sent by: "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU> 20.02.2004
05:35 Please respond to
"ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>


To
ADSM-L AT VM.MARIST DOT EDU
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/IBM@IBMUS
Internet e-mail: storman AT us.ibm DOT com

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 <gwichman AT ZANTAZ DOT COM>
Sent by: "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU> 02/19/2004
15:26 Please respond to
"ADSM: Dist Stor Manager"


To
ADSM-L AT VM.MARIST DOT EDU
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.