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 |
When reorg is used?
Is it Possible to read from PS file and write it to database by using dynamic sql(execute immediate)
What is the difference between db2 and oracle?
Name the different types of Table spaces.
What is check constraint. Explain with example.
Is ibm db2 open source?
What is db2? Explain.
Can I use LOCK TABLE on a view?
I HAVE 2 TABLES ONE IS EMP_TABLE AND ANOTHER DEPT_TABLE.EMP_TABLE CONTAINS NAME,DEPTNO,DEPTNAME,LOCATION AND DEPT_TABLE CONTAINS DEPTNO,DOJ(DATE OF JOINING).I WANT TO DISPLAY NAME,DEPTNAME,DOJ AND WHO ARE JOINED BETWEN 01- JAN-2007 TO 01-JAN-2008?
How to find the number of rows in db2 tables?
What is tablespace?
When you are working with the project after coding what will u do? Like what type of documents u will prepare? How will u do testing?