Prev: MDC on date column?
Next: Locked by agent id 0 huh!!
From: Serge Rielau on 20 Jul 2010 23:38 On 7/20/2010 4:30 PM, Joachim M�ller wrote: > indeed this was a feature. Our developer told me that he has to > rewrite all procedure after upgrading to 9.7 and activate > CURRENTLY COMMITTED , to do a commit after each sql. Is this true? I'm not sure I follow. Generically I can say that relying on locks to synchronize sessions on queries does not work with CURRENTLY COMMITTED. That is the reason why we don't force the new semantics. We ever so gently nudge people instead. :-) -- Serge Rielau SQL Architect DB2 for LUW IBM Toronto Lab |