Re: Long transaction

This is a multi-part message in MIME format. ---------------------------------259741395814773 Content-Transfer-Encoding: 7bit Content-Type: text/plain; charset=us-ascii akent@cix.compulink.co.uk ("Andy Kent") wrote: >I think we're talking at cross purposes a bit here. The scenario under >which you might decide to set the high water marks at or just below 50% >is if all log usage was down to one process - therefore, you need the >same amount of space to be able to roll it back. > I dont believe that the rollback process requires the same amount of log space that was utilized by the transaction being rolled back. Compensatory Log Records (CLR) are written back at the time of a rollback. As per the Informix manual,the CLR is a 24 byte record and is generated for each record that is rolled back. The CLR points back to the log record that is being undone. (Though the manual states that sometimes the compensating operation generates a new log record - I donot under what conditions this occurs). But overall, I think that log space required for rollback should be less than the log space used by the original transaction. Raj ---------------------------------259741395814773 Content-Transfer-Encoding: 7bit Content-Type: ---------------------------------259741395814773--