What is isolation level?
- 4 Answers
- 6383 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 |
What is a synonym? How is it used?
What will happen, while trying to close the closed cursor.
What do you mean by between and in? Is between inclusive of specified range values?
Explain the use of the WHERE clause.
What statistic will tell the DBA how must space can be reclaimed from dropped table spaces on the next reorg run?
What is a clustered index?
How do run the JCL which has 25 steps by skipping the following steps 5, 10,15 and 25 without using COND statement
Why do we use cursor?
List down the data types in the db2 database.
What is the purpose of the WHENEVER statement?
Are views updatable ?
COBOL PRECOMPILER ERROR: "XXXXXX" (TABLE) PREVIOUSLY DECLARED OR REFERENCED DCLGEN VARIABLES GETS IMPORTED TWICE FOR ONLY ONE EXEC SQL STATEMENT. WHAT COULD BE THE PROBLEM?
COBOL 
