ADSM-L

Re: [ADSM-L] deleted management class in database

2007-09-07 10:06:55
Subject: Re: [ADSM-L] deleted management class in database
From: "Collins, Brenda" <brenda.s.collins AT MEDTRONIC DOT COM>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Fri, 7 Sep 2007 09:02:30 -0500
 You may want to run this against archives:

select ll_name, state, backup_date, deactivate_date, class_name from archives 
where node_name = '<node-name>'

Brenda

-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On Behalf Of 
Keith Arbogast
Sent: Friday, September 07, 2007 8:44 AM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Re: [ADSM-L] deleted management class in database

Bill,
By 'current nodes' I mean ones we are backing up daily, not ones retired but 
somehow still in the database.

I had misread or misremembered the description of what happens when a 
management class is deleted, and expected any files, inactive or active, bound 
to a deleted to be rebound to the default management class for the domain, etc. 
 In a hurry, I couldn't find the documentation on that to clarify the behavior.

I did run the query you suggested; select ll_name, state, backup_date, 
deactivate_date, class_name from backups where node_name
= '<node-name>'   The result was 'ANR2034E SELECT: No match found
using this criteria'.

This makes me wonder whether the original query had a, subtle to me but glaring 
to others, logic error.  I am now running a simpler query; "select node_name 
from backups where class_name = '<mystery_class>'".  It may run for awhile, so 
I am sending this ahead in hope of additional suggestions.

With my thanks,
Keith Arbogast

___________________________________________________________________________________________________
CONFIDENTIALITY AND PRIVACY NOTICE
Information transmitted by this email is proprietary to Medtronic and is 
intended for use only by the individual or entity to which it is addressed, and 
may contain information that is private, privileged, confidential or exempt 
from disclosure under applicable law. If you are not the intended recipient or 
it appears that this mail has been forwarded to you without proper authority, 
you are notified that any use or dissemination of this information in any 
manner is strictly prohibited. In such cases, please delete this mail from your 
records.

To view this notice in other languages you can either select the following link 
or manually copy and paste the link into the address bar of a web browser: 
http://emaildisclaimer.medtronic.com