What is isolation level?
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 |
Do we have any optinon to search part of integer in DB2 as we have for character Like,SUBSTR optins?
what is the maximum number of tables that can be joined ?
How can you find out which query is taking lot of time to execute in cobol-db2 program ?
what is the role of the cursor in db2?
Parm value passed is PARM=(10,20). how do code linkage section and how would you add these two passes values and show result in cobol program.
Comment whether the cursor is closed during commit or not.
How can tablespace be moved to another dasd volume that is allocated for that tablespace?
how to execute qcmdexc in rpgle?plz write code also?
How to connect to db2 database from windows command line?
What is check constraint. Explain with example.
What do you mean by cursor?
Explain the use of the WHERE clause.