A quick way to find nodes that are not in a collocation group and how much data they are using up. I one onsite stgpool that uses collocation so I specify that I only want to look at data in that stgpool.
select nod.node_name, nod.collocgroup_name, sum(oc.physical_mb/1024) as GB from nodes nod, occupancy oc where nod.node_name=oc.node_name and oc.stgpool_name='MYSTGPOOL' group by nod.node_name, nod.collocgroup_name
This is how I find out what tapes I need to move data off of after running the above query and if I define nodes into a collocation group when they previous where not in one. This was I can reclaim tapes immediatly rather than waiting for data to expire off the tape and space reclaimation to run against the tape.
select distinct volume_name from volumeusage where node_name IN ('NODE1', 'NODE2', 'NODEX') and stgpool_name='MYSTGPOOL'
I hope to update this list as I think of other selects I use often.
