Yet another approach is to check if the non-collocated need collocation:
select node_name, sum(physical_mb) as "STORAGE"
from occupancy where node_name in (select
node_name from nodes where collocgroup_name is
null and domain_name=upper('$1')) group by
node_name
Fred Johanson
TSM Administrator
University of Chicago
773-702-8464
-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of
Richard Sims
Sent: Thursday, December 06, 2007 7:23 AM
To: ADSM-L@VM.MARIST.EDU
Subject: Re: [ADSM-L] select query for nodes in no collocation group
Another approach is:
select node_name from volumeusage where stgpool_name='________'
to verify if the nodes you expect are actually participating in a
group-collocated storage pool.
Notes:
- Nodes may participate in a group-collocated storage pool and
not be defined in a collocation group, such that collocation by
node would then be in effect for such clients, and make for more
tape use than you might expect.
- The VOLUMEUSAGE table is expensive to search, so do only when
necessary.
Richard Sims at Boston University
