Regarding Isolation level

santosh100678 · New User Joined: 21 Sep 2009 Posts: 55 Location: Kolkatta

Hi,

I have confusion different isolation level.

Isolation Level Read Update Insert
1. RR
2. RS
3. CS
4. UR

my question is that which scenario we can used above isolation level
suppose if i update a table can i use CS because it is page lock.
during insertion can is use RR .
during updation can i use RS because it will lock only qualify rows
UR when we can use.

dick scherrer · Posted: Thu May 06, 2010 8:15 pm

Hello,

Is there some reason you want others to read the documentation for you?

Start here:
publibz.boulder.ibm.com/cgi-bin/bookmgr_OS390/handheld/Connected/BOOKS/dsnsqj10/4.4.7

When you have some specific question, post what you found and your doubt. Someone will be able to clarify.