var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Db2 locking on version 9.5
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.
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.