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:ADSM-L AT VM.MARIST DOT EDU] On Behalf Of
TSM_User
Sent: Friday, January 21, 2005 11:33 PM
To: ADSM-L AT VM.MARIST DOT 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 <psz1 AT CORNELL DOT EDU> 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: psz1 AT cornell DOT edu

                
---------------------------------
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