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)?
|