Re: Db2, Oracle, SQL Server

Serge Rielau apparently said,on my timestamp of 7/02/2005 1:23 AM:

>
> That would be useless indeed. But no, it means that if the log bites its
> tail it will complain. That is if there is a long running transaction
> that prevents overwriting. Don't knwo of hands what happens. Obviosu
> reactiosn woudl be to either rollback the long running transaction to
> snip the tail or to disallow write transactions until the log is
> extended. By using a circular log you agree that up are ok without
> rollforward recovery, perfect for my laptop.

Shades of ORA-1555, eh?
The more they are "different", the more like they sound...

>
> In DB2 the most memory is consumed by
> the bufferpool. Locklist size is not an issue in reality.
> If it ain't a size issue it belongs in memory.

Yeah? So why the lock escalation in the first place?

-- 
Cheers
Nuno Souto
in sunny Sydney, Australia
wizofoz2k_at_yahoo.com.au.nospam