My default management class is STANDARD. This means that the CLASS_NAME
column of the ARCHIVES table only reflects the class name when it is not the
default management class name. This sounds like a bug, except that these
columns aren't documented anywhere as far as I know, so it's not a bug, it's
a feature.
>Go to the active policy set and check which Mgmt class is default .
>Default is not the mgmt class
>:)))
>
>
>
> paul baines
> <paulbaines@HO To: [EMAIL PROTECTED]
> TMAIL.COM> cc: (bcc: MUSTAFA
>BAYTAR/ATIM/ICECEK)
> Sent by: Subject: Re: AW: finding
>unused mgmt classes - why didn't this work?
> "ADSM: Dist
> Stor Manager"
> <[EMAIL PROTECTED]
> IST.EDU>
>
>
> 18.04.2001
> 16:10
> Please respond
> to "ADSM: Dist
> Stor Manager"
>
>
>
>
>
>Hi,
>
>here is a management class I use for archive:
>
>tsm: ADSM_SP02>q copygroup UNIX t=a
>
>Policy Policy Mgmt Copy Retain
>Domain Set Name Class Group Version
>Name Name Name
>--------- --------- --------- --------- --------
>UNIX ACTIVE STANDARD STANDARD 3,650
>UNIX STANDARD STANDARD STANDARD 3,650
>
>and a select from the database:
>
>tsm: ADSM_SP02>select * from archives where node_name='SV001463' and
>filespace_name='/test_adsm' and hl_name='/tmp/' and type='FILE'
>ANR2963W This SQL query may produce a very large result table, or may
>require a
>significant amount of time to compute.
>
>Do you wish to proceed? (Yes/No) y
>
> NODE_NAME: SV001463
>FILESPACE_NAME: /test_adsm
> TYPE: FILE
> HL_NAME: /tmp/
> LL_NAME: tsm_actlog_SP01.arc
> OBJECT_ID: 209238661
> ARCHIVE_DATE: 2001-04-12 15:22:06.000000
> OWNER: root
> DESCRIPTION: TSM ACTLOG archive SP01
> CLASS_NAME: DEFAULT
>
> NODE_NAME: SV001463
>FILESPACE_NAME: /test_adsm
> TYPE: FILE
> HL_NAME: /tmp/
> LL_NAME: tsm_actlog_SP01.arc
> OBJECT_ID: 209696157
> ARCHIVE_DATE: 2001-04-15 00:39:04.000000
> OWNER: root
> DESCRIPTION: TSM ACTLOG archive SP01
> CLASS_NAME: DEFAULT
>
>more... (<ENTER> to continue, 'C' to cancel)
>
>
>This says that my class name is "DEFAULT", but I don't have a class name
>"DEFAULT", it's called "STANDARD". Here "DEFAULT" would seem to be saying
>that the class name used is the default class name and not a class name
>called default. Am I understanding this correctly?
>
>Then CLASS_NAME is only the class name if it isn't the default class,
>otherwise it's DEFAULT. Or did I have too much to dream last night?
>
>
>
> >
> >TRY (if you have some time):
> >
> >select node_name,class_name,count(*) from backups where type <>'DIR'
>group
> >by node_name,class_name
> >
> >to have an overview about your used managementclasses.
> >
> >Regards, Stefan Holzwarth
> >
> >
> > > -----Urspr|ngliche Nachricht-----
> > > Von: Gina Glenewinkel [mailto:[EMAIL PROTECTED]]
> > > Gesendet am: Dienstag, 17. April 2001 17:18
> > > An: [EMAIL PROTECTED]
> > > Betreff: finding unused mgmt classes - why didn't this work?
> > >
> > > Some time ago I posted to this list a question about how to
> > > find out if my
> > > old management classes are still managing any client data. A
> > > couple of you
> > > responded suggesting this select statement: select * from
> > > archives where
> > > class_name='classname' and the same for backups. I ran
> > > this on several
> > > management classes and got "no match found for this query".
> > > Thinking that
> > > meant there was no data found governed by that management
> > > class, I deleted
> > > it and got the expected message about any data will be rebound to the
> > > default management class. I did not expect any data to be
> > > rebound. Turns
> > > out, I deleted some active management classes by mistake
> > > because I thought
> > > they weren't being used.
> > >
> > > Can anyone tell me why my select statement didn't work as expected?
> > >
> > > /gina
> > >
>
>_________________________________________________________________________
>Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.
_________________________________________________________________________
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.
