Try looking at the ANR4391I message that are in the actlog during the
expiration process. Probably need EXPQUIET NO in the DSMSERV.OPT file. It'll
at least get you down to which node/filespace is using a management class,
but not lower than that unless you're willing to query on the BACKUPS
table...and that is painfull!

 ANR4391I Expiration processing node DSMS0200, filespace \\dsms0200\c$, fsId
1, domain STANDARD, and management class TRAINING - for BACKUP type files.

-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU]On Behalf Of
Richard Sims
Sent: Wednesday, October 20, 2004 9:05 PM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Re: Select Filespaces used by Management Classes


>Does anyone know a SQL command that would show all filespaces that are
>assigned to a management classes?

That's problematic, in that filespaces are not assigned to management
classes - file system objects are, and for a given file system, its
directories and files are often spread over multiple classes.  The
least costly way to proceed would be to sample a few files and
directories and hope to extrapolate from that.  Probably not worth it.

   Richard Sims