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:[email protected]] On Behalf Of Larry Clark Sent: Wednesday, March 18, 2009 12:28 PM To: [email protected] 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" <[email protected]> To: <[email protected]> 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:[email protected]] On Behalf Of Botelho, Tiago (External) Sent: Wednesday, March 18, 2009 11:27 AM To: [email protected] 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:[email protected]] On Behalf Of Larry Clark Sent: sábado, 14 de Março de 2009 22:13 To: [email protected] 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.
