Re: Db2, Oracle, SQL Server

From: Mark A <nobody_at_nowhere.com>
Date: Sun, 6 Feb 2005 08:12:40 -0700
Message-ID: <dtGdnfnc0YTlrpvfRVn-3w@comcast.com>

"Noons" <wizofoz2k_at_yahoo.com.au> wrote in message news:42060133$0$4098$5a62ac22_at_per-qv1-
> You mean to say rollback doesn't work with circular logs?
> Now, there is a feature that is sooooooo useful....
>

No I didn't say that. Transaction rollback does work with DB2 circular logs.

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

You can allocate up to 2GB of memory for the DB2 locklist. Received on Sun Feb 06 2005 - 09:12:40 CST