ADSM-L

Re: select statement for disk pools

2002-10-02 12:59:40
Subject: Re: select statement for disk pools
From: Alex Paschal <AlexPaschal AT FREIGHTLINER DOT COM>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Wed, 2 Oct 2002 09:59:10 -0700
Joseph,

Each client can back up files to multiple disk pools depending on which
management classes/copygroups it's binding files to in the include/exclude
list.  So to do this, you would have to select against your backups and
mgmtclass tables or your contents and volumes tables, both of which would be
pretty painful.  It also wouldn't be "hard" information because there may be
clients that COULD go to a certain diskpool but haven't because the included
files haven't existed yet.

It would be more correct to say all your clients in domain X can go to any
of the diskpools specified by copygroups in domain X.

select domain_name, class_name, destination from bu_copygroups where
set_name='ACTIVE' and destination in (select stgpool_name from stgpools
where devclass='DISK')

select domain_name, node_name from nodes

I hope this helps.

Alex Paschal
Storage Administrator
Freightliner, LLC
(503) 745-6850 phone/vmail

-----Original Message-----
From: Joseph Dawes [mailto:jdawes AT CHUBB DOT COM]
Sent: Wednesday, October 02, 2002 6:53 AM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: select statement for disk pools


Does anyone have a select statement to draw a correlation between which
cleints go to which disk pools?






Joseph Dawes
I/T Infrasctructure - Unix Technical Support
Chubb & Son, a Division of Federal Insurance Company
15 MountainView Road
Warren,New Jersey 07059

Office:908.903.3890

<Prev in Thread] Current Thread [Next in Thread>