pike wrote:
DB2 UDB 8.1 FP7
We are getting intermittent deadlocks (911 RC 2) even when U row-lock
has been secured.
The transaction is as follows:
1) Select current application number value from table. To guarantee
uniqueness of the application number SELECT FOR UPDATE statement is
used.
2) Calculate new application number value.
3) Store new application number value back to database with UPDATE
statement.
How is the calculation in step 2 done? If it's not too complicated or can
be wrapped in a UDF, then you could simply condense all three steps into a
single one.
--
Knut Stolze
DB2 Information Integration Development
IBM Germany