Hi All,

In T1 transaction I am select few columns from table X which as id,Name as primary key .
Now I am starting a new transacrion T2 in which I am inserting a row with unique name and same Id as in select.

This is causing a deadlock. The same thing use to work with Db28.2 and I am not sure of all configuration setting s we did then.

Database Isolations level is CS.
db2set DB2_SKIPINSERTED=ON
db2set DB2_SKIPDELETED=ON
db2set DB2_EVALUNCOMMITTED=ON

Since we have high level of concurracy in our application we would not like to change the isolation level.

It seems that their is page level locking on table instead of row level .

Am i missing something .
All locks go away with Db29.7.

Any help will appreciated.

thanks
sreddy