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_at_attbi_s02>
Date: Thu, 21 Oct 2004 01:10:55 GMT
Message-ID: <z0Edd.401003$mD.388664_at_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 Thu Oct 21 2004 - 03:10:55 CEST