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