Interested to Buy Any Domain ? << Click Here >> for more details...
What is isolation level?
- 4 Answers
- 7282 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 |
Comment whether the cursor is closed during commit or not.
Name some fields from SQLCA.
What is the use of commit in db2?
What is netezza database?
What is the error code -803 ?
If there is no row in Emp table with Ename as Raghava and you run the below queries in SPUFI. 1.select Ename from EMP wher Ename = 'raghava' 2.Select count(*) from EMP where Ename = 'raghava' What is SQLCODE shown up in SPUFI
Why cursor is used in db2?
Which command is used to remove all rows from a table?
I understand Join always perform better than subqueries. Then what is the advantage/use of Subqueries/correlated subqueries etc.,in DB2 programming.Please explain.
How would you move a tablespace (using STOGROUP) to a different DASD volume allocated to that tablespace?
Bind concepts in DB2 cobol
10 Answers IBM, TCS, TRD, Virtusa,
can any one give the list of some important sql abend codes which r frequently asked in interviews?
COBOL 
