Re: AW: finding unused mgmt classes - why didn't this work?
Just an interesting little tidbit. I thought I would get around this little quirk by calling my management class 'Default'. This would reduce the confusion and it is a name that suits the class. YOU CAN'T. I stuck with 'standard'. -Original Message- From: Richard Sims [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 18, 2001 11:20 AM To: [EMAIL PROTECTED] Subject: Re: AW: finding unused mgmt classes - why didn't this work? >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? Yes, the generic identifier "DEFAULT" will be found for CLASS_NAME. >From my notes: In archiving: CLASS_NAME will be "DEFAULT" (the generic identifier for the default management class) for archiving done without using ARCHmc. Interestingly, if you use ARCHmc specifying the management class name which is the default management class, its actual name will show up under CLASS_NAME; and if you specify -ARCHmc=default, CLASS_NAME will be "DEFAULT". Life would be too dull without things like this. Richard Sims, BU
Re: AW: finding unused mgmt classes - why didn't this work?
>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? Yes, the generic identifier "DEFAULT" will be found for CLASS_NAME. >From my notes: In archiving: CLASS_NAME will be "DEFAULT" (the generic identifier for the default management class) for archiving done without using ARCHmc. Interestingly, if you use ARCHmc specifying the management class name which is the default management class, its actual name will show up under CLASS_NAME; and if you specify -ARCHmc=default, CLASS_NAME will be "DEFAULT". Life would be too dull without things like this. Richard Sims, BU
Re: AW: finding unused mgmt classes - why didn't this work?
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 > 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 > >PolicyPolicyMgmt CopyRetain >DomainSet Name Class Group Version >NameName Name >- - - - >UNIX ACTIVESTANDARD 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.00 > 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.00 > OWNER: root >DESCRIPTION: TSM ACTLOG archive SP01 > CLASS_NAME: DEFAULT > >more... ( 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.
Re: AW: finding unused mgmt classes - why didn't this work?
Apologies to everyone on the list. I hit 'Reply' to reply to Paul personally, I didnt mean my last post to hit the list. Thankyou, Matthew Warren.
Re: AW: finding unused mgmt classes - why didn't this work?
Did you have to much to what last night? I think you had too muchof it, whatever it was. ___ Matthew Warren. GZPTXW EDS Core Infrastructure, UK Technical Services Group, Wavendon Tower, Milton Keynes. +44(0)1908284481 ___ > -Original Message- > From: paul baines [mailto:[EMAIL PROTECTED]] > Sent: 18 April 2001 14:10 > To: [EMAIL PROTECTED] > Subject: Re: AW: finding unused mgmt classes - why didn't this work? > > > Hi, > > here is a management class I use for archive: > > tsm: ADSM_SP02>q copygroup UNIX t=a > > PolicyPolicyMgmt CopyRetain > DomainSet Name Class Group Version > NameName Name > - - - - > UNIX ACTIVESTANDARD 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.00 > 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.00 > OWNER: root >DESCRIPTION: TSM ACTLOG archive SP01 > CLASS_NAME: DEFAULT > > more... ( 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.
Re: AW: finding unused mgmt classes - why didn't this work?
Go to the active policy set and check which Mgmt class is default . Default is not the mgmt class :))) paul baines 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 PolicyPolicyMgmt CopyRetain DomainSet Name Class Group Version NameName Name - - - - UNIX ACTIVESTANDARD 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.00 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.00 OWNER: root DESCRIPTION: TSM ACTLOG archive SP01 CLASS_NAME: DEFAULT more... ( 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.
Re: AW: finding unused mgmt classes - why didn't this work?
Hi, here is a management class I use for archive: tsm: ADSM_SP02>q copygroup UNIX t=a PolicyPolicyMgmt CopyRetain DomainSet Name Class Group Version NameName Name - - - - UNIX ACTIVESTANDARD 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.00 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.00 OWNER: root DESCRIPTION: TSM ACTLOG archive SP01 CLASS_NAME: DEFAULT more... ( 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.
AW: finding unused mgmt classes - why didn't this work?
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 >