Seeking collocation select statement.

[moorecj79]

Hi,

I've recently implemented collocation by group on my TSM server. Does a select statement exist that can report on how many tapes the collocation groups are currently using? AND is there a select statement that can report on tape usage history by collocation group?

It would be VERY handy to see over time how the groups are consuming tapes.

Many thanks,
Chris.

 

[nezih]

select distinct volume_name from volumeusage where node_name in (select node_name from collocgroup where collocgroup_name='YOURCOLLOCGROUP')