Re: Delete a single file on TSM

I want to thank everyone for all their valuable inputs!

This forum rocks.

-----Original Message-----
From: Stapleton, Mark [mailto:mark.stapleton AT BERBEE DOT COM]
Sent: Wednesday, April 28, 2004 12:25 PM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Re: Delete a single file on TSM

From: ADSM: Dist Stor Manager on behalf of John Bremer
>run a select * from backups with the required node_name, filespace_name,
>etc to find the object id, then delete object 0 xxxxxxxxx

...and guess what happens if you do this? If everything is copacetic, it
deletes the object.

And if everything is *not* copacetic? It will corrupt the database and down
you go If you are lucky, it will go down immediately; if you are not, it may
not go down for a day or three. And when you call Tivoli support and tell
them what you did, they'll tell you, "Gee, 'delete object' is an unsupported
command, to be used only at the direction of Tivoli support. Guess you'll
have to restore your database from your last good backup. Thanks for
playing!" If it's been two or three days since the last good db backup
you've done, your TSM system is good and truly hosed.

Do yourself a favor, Calvin. *Do not* do this. As Mr. Sims commented in an
earlier posting, stay within the bounds of policies established by your IT
infrastructure. Deleting a single file pointer from the TSM database isn't
worth the risk. Why do you want to do this anyway?

--
Mark Stapleton


---------------------------------------

The information contained in this e-mail message, and any attachment thereto, 
is confidential and may not be disclosed without our express permission.  If 
you are not the intended recipient or an employee or agent responsible for 
delivering this message to the intended recipient, you are hereby notified that 
you have received this message in error and that any review, dissemination, 
distribution or copying of this message, or any attachment thereto, in whole or 
in part, is strictly prohibited.  If you have received this message in error, 
please immediately notify us by telephone, fax or e-mail and delete the message 
and all of its attachments.  Thank you.

Every effort is made to keep our network free from viruses.  You should, 
however, review this e-mail message, as well as any attachment thereto, for 
viruses.  We take no responsibility and have no liability for any computer 
virus which may be transferred via this e-mail message.