Re: Comparison of DB2 and Oracle?

From: Jim Kennedy <kennedy-downwithspammersfamily_at_attbi.net>
Date: Thu, 21 Oct 2004 01:10:55 GMT
Message-ID: <z0Edd.401003$mD.388664@attbi_s02>

"Serge Rielau" <srielau_at_ca.ibm.com> wrote in message news:2tm002F21a6qfU2_at_uni-berlin.de...
> DB2 UDB for LUW does not have page locks.. Only row and table level

Doesn't it still have a problem with dynamic SQL such that it locks the plan table so people who need to bind programs with the database have to wait until the transaction competes. Thus if one issues dynamic SQL and doesn't commit for several minutes it will prevent (serialize) those programmers from binding their programs with the database. Jim Received on Wed Oct 20 2004 - 20:10:55 CDT