Hallo, Could someone explain a little more about 'expiration continuing where it left off' - this seems to imply to me that 'Cancel Proccess' on an expiration causes the work the expiration has done to roll back, whereas 'cancel expiration' does not?
Matt. _-'-_ -|- -----Original Message----- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of TSM_User Sent: Friday, January 21, 2005 11:33 PM To: ADSM-L@VM.MARIST.EDU Subject: Re: TSM DB -- How big is too big? If you use the durration or as Richard mentioned using the cancel expiration command then it doesn't start at the begining. But if you just cancel the process with "can proc" then I believe it does start at the begining. Paul Zarnowski <[EMAIL PROTECTED]> wrote: Expiration is a key metric to determining whether your database is too large. If you cannot keep up with expiration, then your situation can deteriorate very quickly (as we discovered). A large database can also result in performance problems when doing no-query-restores or other db queries. Cancelling expiration does *not* cause you to start at the beginning again. It is fine to do this. Running multiple instances on one server may be reasonable. We did this when we split our database. It really depends on whether you are bottlenecked on a hardware resource or not. If you can't complete a full expiration in a reasonable time period (i.e., a couple days to a week), then I would say it is time to split your database. ..Paul At 01:43 PM 1/21/2005, Robin Sharpe wrote: > >How long does your expiration run and how have you managed it? > >Well, that's an interesting story... we are not doing any expirations right >now due to reasons beyond my control. When we were running expirations, it >ran about an hour.... but the database was "only" about 180GB then. > >Robin Sharpe >Berlex Labs -- Paul Zarnowski Ph: 607-255-4757 719 Rhodes Hall, Cornell University Fx: 607-255-8521 Ithaca, NY 14853-3801 Em: [EMAIL PROTECTED] --------------------------------- Do you Yahoo!? Yahoo! Search presents - Jib Jab's 'Second Term' ___________________________ Disclaimer Notice __________________________ This message and any attachments are confidential and should only be read by those to whom they are addressed. If you are not the intended recipient, please contact us, delete the message from your computer and destroy any copies. Any distribution or copying without our prior permission is prohibited. Internet communications are not always secure and therefore Powergen Retail Limited does not accept legal responsibility for this message. The recipient is responsible for verifying its authenticity before acting on the contents. Any views or opinions presented are solely those of the author and do not necessarily represent those of Powergen Retail Limited. Registered addresses: Powergen Retail Limited, Westwood Way, Westwood Business Park, Coventry, CV4 8LG. Registered in England and Wales No: 3407430 Telephone +44 (0) 2476 42 4000 Fax +44 (0) 2476 42 5432