Thanks for the pointer Richard. I have Client Opt files but completely
overlooked adding the Management classes in them. Its working like a
dream now.

Regards
Adrian Compton
ASPEN PHARMACARE

-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT vm.marist DOT edu] On Behalf Of
Richard Sims
Sent: 08 December 2006 14:10 PM
To: ADSM-L AT vm.marist DOT edu
Subject: Re: [ADSM-L] TSM SQL Listing Client Schedule showing MGMT Class

On Dec 8, 2006, at 5:30 AM, adrian_compton wrote:

> Hi,
>
> I would really appreciate some help with a script for the following.
>
> I want to list all my schedules and be able to see what Management
> class
> they are using.
> I have set the Management Class in the various Client dsm.opt files.
> Is there a place where this info gets stored in TSM when the backup
> takes place? I have looked through all the tables in Tivoli and
> cant see
> anything like what I require without going through all my Clients
> individually.

Adrian -

It may be beneficial to review the TSM Concepts redbook, to better
understand how the product operates...  Schedules don't "use a
management class".  File system objects are individually bound to
management classes according to explicit, separate Include statements
as well as implicit rules (as in directory binding).  These end up
recorded, object by object, in the very large Backups table.  If you do:

     SELECT * FROM SYSCAT.COLUMNS where tabname='BACKUPS'

you will see the column definitions.  This is not a table you want to
routinely traverse.  Your site may want to consider using Client
Option Sets, where you can centrally define common Include
statements, to know which management class new backups are using.
Where no management class is chose, the Default Management Class is
in effect, which you can presume for files, and directories are bound
to the management class with the longest RETOnly value, except where
DIRMc is specified.  Again, this is all described in the Concepts
redbook, as well as the Admin Guide.

    Richard Sims