Topic
1 reply Latest Post - ‏2011-10-25T18:36:12Z by MatthiasNicola
VV4H_mario_fernandes
43 Posts
ACCEPTED ANSWER

Pinned topic Sanpshot isolation level

‏2011-10-24T16:56:33Z |
Hi

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.

Thanks

Mario
Updated on 2011-10-25T18:36:12Z at 2011-10-25T18:36:12Z by MatthiasNicola