I have a long running query on the entire table.
To prevent the application from locking up I am using UR
Eg. Select * from table with UR;
But now I noticed that I am getting some inconsistent data.
Is there a Snapshot read in DB2 9.7 for LUW.
I need the data to be stable without locking it.
I know about RS and CS but they both lock rows.
Pinned topic Sanpshot isolation level
Answered question This question has been answered.
Unanswered question This question has not been answered yet.
Updated on 2011-10-25T18:36:12Z at 2011-10-25T18:36:12Z by MatthiasNicola
MatthiasNicola 120000E28R322 Posts
Re: Sanpshot isolation level2011-10-25T18:36:12ZThis is the accepted answer. This is the accepted answer.Hi Mario,
since your question is not related to XML, I think you would get more and better responses if you post your question in the general DB2 forum at this URL:
Be sure to say which version and fixpack of DB2 you are using.
In DB2 9.7 there is a concurrency control option called "currently committed" that might be helpful for you. See: