Interested to Buy Any Domain ? << Click Here >> for more details...
What is isolation level?
- 4 Answers
- 7286 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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 |
Answer / narasimharao
it specifies level of locking is calling isolation
| Is This Answer Correct ? | 2 Yes | 0 No |
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 |
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 |
how to check the table is empty or not?
Can we use select query in a loop to fetch multiple rows in a COBOL PROGRAM? If so, what is the advantage of cursor?
How do I handle -911 (deadlock) error in a db2 program so that the program will never abend?
What is load replace in db2?
How does one bind 2 versions of a CICS transaction with the same module name in two different CICS regions that share the same DB2 subsystem?
what is the difference between normal select query and currosor
In BIND, isolation level parameter specifies the duration of page lock and ACQUIRE, RELEASE also do almost the same thing. What is the exact difference between the two? Do they work in conjunction while executing SQL queries and obtaining locks?
Comment whether dclgen is mandatorily used. If not, then what is the point of using it?
What is database alias db2?
How to define the data items to receive the fetch items for the SQL?
what is cursor stability?
What techniques will be used to avoid deadlock??
COBOL 
