Isolation level 1

[widowweeds]

Dear Members,

Can anybody enlighten me as to what UR stands for and how locks are handled at the isolation level when this option is chosen in a cursor declaration as opposed to CS or RR?

Thanks in advance for any assistance given.

 

[MarcLodge]

Hi WW,
ISOLATION(UR) will perform an Uncommitted Read, sometimes known as a dirty read. This will obtain data that has not been committed and may subsequently be backed out. It is therefore treated with caution.

DB2 locking is quite a large topic which you'll find an awful lot of information on the net. Try these two sites for starters:

http://www.anesi.com/v41004.htm

http://www.csa.ru/dblab/DB2/db2s0/isolvl.htm#HDRISOLVL

Marc

 

[widowweeds]

Hi Marc,

Thanks for the links. Great stuff once again.