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:[EMAIL PROTECTED] On Behalf Of Keith Arbogast Sent: Friday, September 07, 2007 8:44 AM To: ADSM-L@VM.MARIST.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