What is isolation level?

Question Posted / guest

4 Answers
5665 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

What is isolation level?..

Answer / vignesh

DB2 Provides different levels of protection, To isolate data

1. UN COMMITTED READ
2. CURSOR STABILITY
3. READ STABILITY
4. REPEATABLE READ

Is This Answer Correct ?

2 Yes

0 No

What is isolation level?..

Answer / narasimharao

it specifies level of locking is calling isolation

Is This Answer Correct ?

2 Yes

0 No

What is isolation level?..

Answer / pandurangan

DB2 ensures concurrency through ISOLATION levels, which
determines how data that is accessed or modified by one
transaction is isolated from other transaction.

There are 4 levels of isolation

1) Repeatable Read - if a transaction scans 1000 rows to
retrieve 20 rows, lock is acquired and held on all 1000 rows
until the transaction is complete.

2) Read Stability - If 10 rows are retrieved then lock will
be on 10 rows only till the completion of transaction.

3) Cursor Stability - Only locks the row that is referenced
by a cursor that was declared and owned by the transaction.

4) Uncommitted Read - Its just like read, since you haven't
committed you can see others making changes to it while you
are still on it.

For more details go to http://db2guide.blogspot.ie/

Is This Answer Correct ?

0 Yes

1 No

What is isolation level?..

Answer / narasimharao

there are three types
1.cursor stability
2.rerepeatable read
3.uncommited read or dirty read

Is This Answer Correct ?

0 Yes

2 No

Post New Answer