Re: Db2, Oracle, SQL Server

"Mark A" <nobody_at_nowhere.com> wrote:
> >
> > and when that is all used up, the whole thing grinds to a halt.
> > As I said: that is sooooooo scalable...
> >
> 2 GB is about 250 million locks (the exact amount of memory needed
> depends on whether it is the first lock on a row, subsequent lock on a
> row, or whether you are using 32bit/64bit DB2 instance). When it runs out
> of memory, then it changes to table locks, so if you allocated the
> maximum amount for the locklist DB2 would not grind to a halt unless you
> had more than 250 million tables in your database.

If the table that I am interested in is locked by another process, then I have ground to a halt. It matters not whether 249,999,999 other tables which I have no interest in are locked.

Xho

-- 
-------------------- http://NewsReader.Com/ --------------------
Usenet Newsgroup Service                        $9.95/Month 30GB