ADSM-L

Help with query

2003-08-11 10:22:05
Subject: Help with query
From: Joe Howell <jhowell_tsm AT YAHOO DOT COM>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Mon, 11 Aug 2003 07:21:49 -0700
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?



Joe Howell
Shelter Insurance Companies
Columbia, MO

---------------------------------
Do you Yahoo!?
Yahoo! SiteBuilder - Free, easy-to-use web site design software

<Prev in Thread] Current Thread [Next in Thread>