Re: Db2, Oracle, SQL Server

From: Noons <wizofoz2k_at_yahoo.com.au>
Date: Sun, 06 Feb 2005 22:36:24 +1100
Message-ID: <42060133$0$4098$5a62ac22@per-qv1-newsreader-01.iinet.net.au>

Mark A apparently said,on my timestamp of 6/02/2005 6:56 PM:

> the data load. Log retain is used for rolling back transactions,
> roll-forward recovery, and replication.

You mean to say rollback doesn't work with circular logs? Now, there is a feature that is sooooooo useful....

> DB2 keeps track of all locks (row or table) in memory. The size of the
> locklist memory is configurable. If the locklist memory becomes full, DB2
> will start doing dynamic lock escalation from row locks to table locks, and
> log this event in a diagnostic log file.

That is sooooooooooo scalable....

>>That is more than I want to remember until I have to pick up the >>project again.

Aye. Sooooooo true...

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

Received on Sun Feb 06 2005 - 05:36:24 CST