NOTES: 

These may run for a while.  Watch for wrapped lines to fix.

In the first query, watch for Number of Groups greater than 1 when the
storage pool is supposed to be collocated by group.

In the second query, you will see a line item for each group on each tape.

All of our nodes belong to a group, even if there is only one node in it.


*********************************************


The following query will show:
Pool name, Access, Volume name, # Groups, # Nodes, # FSpaces, % Util, % Recl


select  -
  cast(vu.stgpool_name as char(9)) as "Pool", -
  (select access from volumes where volume_name=vu.volume_name) as "Access",
-
  cast(vu.volume_name as char(9)) as "Volume", -
  cast(count(distinct nd.collocgroup_name) as decimal(4,0)) as "Groups", -
  cast(count(distinct vu.node_name) as decimal(3,0)) as "Nodes", -
  cast(count(distinct vu.filespace_name) as decimal(5,0)) as "FSpaces", -
  (select pct_utilized from volumes where volume_name=vu.volume_name) as
"Util", -
  (select pct_reclaim from volumes where volume_name=vu.volume_name) as
"Recl" -
from -
  volumeusage vu, nodes nd -
where -
  vu.node_name=nd.node_name -
group by -
  vu.stgpool_name, vu.volume_name -
order by -
  "Groups" desc, "Nodes" desc, "FSpaces" desc



****************************************************



This query will show:

Pool, Access, Volume name, Group name, # Nodes, # FSpaces, % Util, % Recl



select  -
 cast(vu.stgpool_name as char(9)) as "Pool", -
 (select access from volumes where volume_name=vu.volume_name) as "Access",
-
  cast(vu.volume_name as char(9)) as "Volume", -
  cast(nd.collocgroup_name as char(7)) as "Groups", -
  cast(count(distinct vu.node_name) as decimal(3,0)) as "Nodes", -
  cast(count(distinct vu.filespace_name) as decimal(5,0)) as "FSpaces", -
  (select pct_utilized from volumes where volume_name=vu.volume_name) as
"Util", -
  (select pct_reclaim from volumes where volume_name=vu.volume_name) as
"Recl" -
from -
  volumeusage vu, nodes nd -
where -
  vu.node_name=nd.node_name -
group by -
  vu.stgpool_name, vu.volume_name, nd.collocgroup_name -
order by -
  "Access", "Pool", "Volume", "Groups", "Nodes" desc, "FSpaces" desc



***********************************************************************

Bob


-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On Behalf Of
Larry Clark
Sent: Wednesday, March 18, 2009 12:28 PM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Re: [ADSM-L] volumes in a collocation group?

Thanks Fred. That was mentioned previously, but it does not show if other 
servers not in the colloc group are stored on those volumes.
Larry Clark
(518) 712-5138 Home Office


----- Original Message ----- 
From: "Fred Johanson" <Fred AT UCHICAGO DOT EDU>
To: <ADSM-L AT VM.MARIST DOT EDU>
Sent: Wednesday, March 18, 2009 12:34 PM
Subject: Re: [ADSM-L] volumes in a collocation group?


Q noded col=name-of-collocpool stg=name-of-stgpool

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 
Botelho, Tiago (External)
Sent: Wednesday, March 18, 2009 11:27 AM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Re: [ADSM-L] volumes in a collocation group?

Hi Larry,

I thing that my TSM Server do not have this DB record (version 5.2) , but I 
will try to help you or give you some ideas.

Try sommething similarlike this:

select volume_name from volumeusage where stgpool_name='STORAGEPOOL' group 
by volume_name

try to find where COLLOCG record are (maybe in nodedata table)

See on TSM Server commnd line all the tables from db:

h select
select * from tables
select * from columns
...


Useful scripts can be made with TSm DB


Best regards

Tiago



-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On Behalf Of 
Larry Clark
Sent: sábado, 14 de Março de 2009 22:13
To: ADSM-L AT VM.MARIST DOT EDU
Subject: [ADSM-L] volumes in a collocation group?

Hi,
Would someone have a query that returns all the volumes in a particular
collocation group (within a copypool)?

This electronic transmission and any documents accompanying this electronic 
transmission contain confidential information belonging to the sender.  This 
information may be legally privileged.  The information is intended only for 
the use of the individual or entity named above.  If you are not the intended 
recipient, you are hereby notified that any disclosure, copying, distribution, 
or the taking of any action in reliance on or regarding the contents of this 
electronically transmitted information is strictly prohibited.