Well, you should only have 1 tape tied up - the last one, right? First the std disclaimer that you should NEVER do this with your real DB backup tapes; but if you want to free up that last, unused DBSNAPSHOT tape:
1) create a file device class 2) run a Dbsnapshot to the file device class 3) run a DELETE VOLHIST to free up the tape that is now the next-to-last DBSNAPSHOT 4) delete the file from (2) using OS-level tools, to get your disk space back. The name of the last Dbsnapshot will still be in volhist. But nobody will care. -----Original Message----- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Bell, Charles (Chip) Sent: Tuesday, July 11, 2006 3:02 PM To: [email protected] Subject: Deleting database snapshot I recently asked about this and received good answers. But what I would like to know is if TSM development is ever going to consider making it to where you can rid yourself of ALL unwanted database backups/snapshots. The docs says "The latest snapshot database backup will not be deleted" when you attempt a 'delete volhist' on them. So is it still correct that I cannot delete these through any method, and if not, is that ever going to change? I have some tapes I could sure use as scratches... :-) If you're curious we went from full database backups to snapshots back to fulls again. God bless you!!! Chip Bell Network Engineer I IBM Tivoli Certified Deployment Professional (ITSM 5.2) Baptist Health System Birmingham, AL ----------------------------------------- Confidentiality Notice: The information contained in this email message is privileged and confidential information and intended only for the use of the individual or entity named in the address. If you are not the intended recipient, you are hereby notified that any dissemination, distribution, or copying of this information is strictly prohibited. If you received this information in error, please notify the sender and delete this information from your computer and retain no copies of any of this information.
