ADSM-L

Re: [ADSM-L] volumes in a collocation group?

2009-03-18 12:34:33
Subject: Re: [ADSM-L] volumes in a collocation group?
From: Fred Johanson <Fred AT UCHICAGO DOT EDU>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Wed, 18 Mar 2009 11:34:00 -0500
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)?