> Does anyone have a script that will show the volumes associated with a
> collocation group?

select distinct vv.volume_name from nodes nn, volumeusage vv -
 where nn.collocgroup_name=upper('$1') and vv.node_name=nn.node_name

You DON'T want to use the "collocgroup" table.

        Wolfgang J. Moeller @ GWDG Goettingen, Germany

Reply via email to