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.