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.
This topic has been locked.
1 reply Latest Post - 2011-10-25T18:36:12Z by MatthiasNicola
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 120000E28R321 PostsACCEPTED ANSWER
Re: Sanpshot isolation level2011-10-25T18:36:12Z in response to VV4H_mario_fernandesHi 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: