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 |
What is scrollable cursor in db2?
Name the different types of Table spaces.
How many Buffer pools are there in DB2 and what are they?
we can code COPY DCLGEN or INCLUDE DCLGEN, At which stage of the precompilation , dclgen get expanded if we write 1) copy 2) include one question about dclgen.. Is it mandatory to use declare table in dclgen.. I think no...but it will be used by the precompiler to validate the table name,column name etc.., can one clear my doubt ..is it necessary to include declare table or not?
If the main program has only cobol statements and subprogram has the db2 statements what is the procedure for precompilation. for which program we need to do the precompilation
Under what circumstances will DB2 allow an SQL statement to update more than one primary key value at a time?
can all users have the privilage to use the sql statement select * (dml)?
What is a DBRM, PLAN ?
What is the function of buffer manager?
How to find last record before record through SQLRPGLE?
What is db2 bind process?
why should we bind the DB2 program . What if we did not BIND a BD2 program ??
9 Answers Infosys, TCS, Xansa,