There is no one-to-one correspondence between filespaces (or nodes) and
management classes. There is a one-to-one correspondence between nodes
and policy domains, and a policy domain has one DEFAULT management
class, but can have many.

There is a one-to-one correspondence between individual files and
management classes, but the column entry in the TSM database is
"DEFAULT" unless a non-default management class is involved.
 
--
Mark Stapleton
CDW Berbee
System engineer
7145 Boone Avenue North, Suite 140
Brooklyn Park MN 55428-1511
763-592-5963
www.berbee.com
 

> -----Original Message-----
> From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On Behalf
Of
> Howard Coles
> Sent: Thursday, February 14, 2008 4:01 PM
> To: ADSM-L AT VM.MARIST DOT EDU
> Subject: [ADSM-L] Find Management Class and copy group info per
filespace
> 
> I have a question, as I've been challenged to provide this
information.
> 
> I need a way to query TSM and find out which Management Class each
file
> space is bound to.  We have some domains that were setup with no less
> than 5 Management Classes, each with copy groups that have vastly
> differing retention policies.  For the Oracle, Exchange, and SQL
server
> backups this is easy, there's a dedicated node and only a few Domains
> and MCs.  But for file spaces this gets more complicated.
> 
> So, if anyone knows of an easy (relatively speaking) SQL Query, or
> series of SQL Queries they have run in the past to do this it would be
> greatly appreciated.
> 
> See Ya'
> Howard Coles Jr.
> Sr. Systems Engineer
> 615-296-3416
> John 3:16!