Re: Help with query
I think that the VOLUMEUSAGE table is probably your best bet for this
info. I'd suggest a query like this:
select distinct volume_name, node_name
order by volume_name, node_name
(substitute your copy storage pool name for POOLNAME).
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.
Joe Howell <jhowell_tsm AT YAHOO DOT COM>
Sent by: "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>
Please respond to "ADSM: Dist Stor Manager"
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Help with query
I've got a collocated offsite copy storage pool and need to get a list of
what nodes are represented on what volumes. The only way I know of is to
issue a "select distinct node_name from volumeusage where
volume_name=<volume>" but this seems inelegant and in any case takes a
VERY, VERY long time. Is there a better way to get this information?
Shelter Insurance Companies
Do you Yahoo!?
Yahoo! SiteBuilder - Free, easy-to-use web site design software