Does anyone have a script that will show the volumes associated with a collocation group?
I'm trying to run this but receive an error; select distinct vu.volume_name, cg.collocgroup_name from volumeusage vu, collocgroup cg where vu.node_name=cg.node_name and vu.stgpool_name='DRMC' group by cg.collocgroup ANR2938E The column 'VOLUME_NAME' is not allowed in this context; it must either be named in the GROUP BY clause or be nested within an aggregate function. Thank you in advance! Laura.
