Re: [ADSM-L] select query for nodes in no collocation group
2007-12-06 09:56:25
Many thanks to you all.
-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU]On Behalf Of
Fred Johanson
Sent: 06 December 2007 14:39
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Re: [ADSM-L] select query for nodes in no collocation group
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:ADSM-L AT VM.MARIST DOT EDU] On Behalf Of
Richard Sims
Sent: Thursday, December 06, 2007 7:23 AM
To: ADSM-L AT VM.MARIST DOT 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
Oxfordshire County Council - rated a four-star 'Excellent' council by the Audit
Commission
The information in this e-mail, together with any attachments, is confidential.
If you have received this message in error you must not print off, copy, use or
disclose the contents. The information may be covered by legal and/or
professional privilege. Please delete from your system and inform the sender of
the error. As an e-mail can be an informal method of communication, the views
expressed may be personal to the sender and should not be taken as necessarily
representing the views of the Oxfordshire County Council. As e-mails are
transmitted over a public network the Oxfordshire County Council cannot accept
any responsibility for the accuracy or completeness of this message. It is your
responsibility to carry out all necessary virus checks. You should be aware
that all emails received and sent by this Council are subject to the Freedom of
Information Act 2000 and therefore may be disclosed to other parties under that
Act. www.oxfordshire.gov.uk
|
|
|