Gerald,

This is a known requirement, is being submitted to the developers thru
SHARE;  a preview=yes option for restore/retrieve, which runs thru the
database as if the restore is being processed --- specifically, to obtain
the list of volumes that will be required.

So far, their response was (a) multi-thread restore feature (in 5.1) will
make this more complicated, so (b) they may not list vols in the actual
sequence (due to new parallelism) -- my answer was "the customer does not
care, they just need the list" (at least, for now), as it's the reality that
customers occasionally over-commit their silo capacity, need to do a restore
while awaiting new hardware to match their (new) capacity requirements.

You could construct a SELECT to do this, but it would take much longer than
the actual restore code to rummage thru the related tables; doing select for
a pseudo-join between backups and volumes -- backups using node and "active"
status, correlating to contents... gotta be a painful way to do it, but the
only precise way to do it.

My favorite, less-precise way (that I use for any real customer situation)
is just select from volumeusage based on node and storage pool name -- that
gets you all the vols occupied, so it's distorted abit (due to versions),
but, hey --- they should realize they need a silo large enough to hold ALL
their backup data, else it's never gonna be lights-out (as intended) and you
gotta go thru this pain!  See Karel's reply for an example of this query...
and watch for the new release info, for IBM's response.

        select distinct volume_name -
                from volumeusage where node_name='XYZ', -
                and filespace_name='ABC', -
                and stgpool_name = 'DEF'

HTH!

Don France
Technical Architect -- Tivoli Certified Consultant
Tivoli Storage Manager, WinNT/2K, AIX/Unix, OS/390
San Jose, Ca
(408) 257-3037
mailto:don_france AT ayett DOT net (change aye to a for replies)

Professional Association of Contract Employees
(P.A.C.E. -- www.pacepros.com)



-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU]On Behalf Of
Gerald Wichmann
Sent: Tuesday, November 26, 2002 9:03 AM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Re: Querying which volumes have a particular file or node


Not exactly the answer I was looking for..

Gerald Wichmann
Senior Systems Development Engineer
Zantaz, Inc.
925.598.3099 (w)

-----Original Message-----
From: Raghu S [mailto:raghu AT COSMOS.DCMDS.CO DOT IN]
Sent: Monday, November 25, 2002 9:53 PM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Re: Querying which volumes have a particular file or node

in Tivoli Storage Resource Manager all these are addressed

raghu.



                    Gerald
                    Wichmann             To:     ADSM-L AT VM.MARIST DOT EDU
                    <gwichman@ZAN        cc:
                    TAZ.COM>             Subject:     Querying which volumes
have a
                    Sent by:             particular file or node
                    "ADSM: Dist
                    Stor Manager"
                    <ADSM-L AT VM DOT MA
                    RIST.EDU>


                    11/26/2002
                    03:25 AM
                    Please
                    respond to
                    "ADSM: Dist
                    Stor Manager"





Given a file with some filenames in it, does someone have a macro/command I
can run against the filenames in that file to determine what volumes those
files are on? I.e. so I can identify which offline volumes I need to put in
my library for a restore before actually running the restore command.

Similarly, given a node, how do I determine what volumes the node has data
backed up to.

I believe both these questions involve a select statement and have been
discussed before so someone should have them handy.

Thanks,
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.


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.