By setting the DRMDBBACKUPEXPIREDAYS, allows you to automatically recycle the TSM DB tapes. This is usually set to something like a 5 day cycle, based on how realsitic it is that you would want to recover your TSM environment back to. This means there will always be a critical volume of tapes used for DB Backup. Be sure to set the REUDE DELAY parameter on the copy storage pools to match the retention of the database backup. This ensures the tape volumes required for that DB will be there, rather than being over written on the standard DRM cycle. (They will go into a pending state).
_____________________________ Ian Smith SAN/TSM Specialist Hitachi Data Systems Certified Professional IBM Tivoli Storage Manager Certified Consultant -----Original Message----- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of PAC Brion Arnaud Sent: 21 September 2006 16:28 To: [email protected] Subject: Re: [ADSM-L] Total newbie question about DB Backups Hi Angus ! You'll probably get somehow disapointed, but there's no way to do what you're asking ! TSM wants a new tape for each DB backup, and the only way to spare your precious scratch volumes would be to use some form of disk storage, thru the mean of a sequential-on-disk device class ... HTH. Cheers Arnaud ************************************************************************ ****** Panalpina Management Ltd., Basle, Switzerland, CIT Department Viadukstrasse 42, P.O. Box 4002 Basel/CH Phone: +41 (61) 226 11 11, FAX: +41 (61) 226 17 01 Direct: +41 (61) 226 19 78 e-mail: [EMAIL PROTECTED] ************************************************************************ ****** -----Original Message----- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Angus Macdonald Sent: Thursday, 21 September, 2006 17:11 To: [email protected] Subject: Total newbie question about DB Backups I'm just in the process of implementing TSM 5.3 for the first time in our environment and I'm following the TSM Implementation Guide (June 2006 edition) redbook very closely ;-) Things are going pretty well so far but I have a bit of an issue with my database backups. Every DB backup seems to use another scratch tape so my 3582 is going to run out of tapes very quickly. My backup command is Backup DB type=full devc=lto2-dc lifted directly from the redbook. How can I limit the number of tapes used for DB backups? I tried limiting the backup to a particular tape volume but the tape is apparently in use after the first backup and cannot be reused. Angus _____________________________________________________________ This email (including any attachments to it) is confidential, legally privileged, subject to copyright and is sent for the personal attention of the intended recipient only. If you have received this email in error, please advise us immediately and delete it. You are notified that disclosing, copying, distributing or taking any action in reliance on the contents of this information is strictly prohibited. Although we have taken reasonable precautions to ensure no viruses are present in this email, we cannot accept responsibility for any loss or damage arising from the viruses in this email or attachments. We exclude any liability for the content of this email, or for the consequences of any actions taken on the basis of the information provided in this email or its attachments, unless that information is subsequently confirmed in writing. If this email contains an offer, that should be considered as an invitation to treat. _____________________________________________________________
