I am using Work objects (asynch beans) running inside websphere app server 6.0. and hibernate as O/R layer.
There are about 80 Work objects, querying and updating tables in DB2 simultaneously.
I have set the lock percentage parameter to 100% for this database and I am sure there is no concurrent access to the same records by more then one thread because each Work object is assigned a different group of records.
Still I get deadlocks after a the application is running for a while (minutes).
Will appreciate any ideas.