Answer Posted / 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 |
Post New Answer View All Answers
File not opened because library is *PROD and debug is UPDPROD(*NO). ? what may be the reason? how to solve it..?
What is runstats db2?
How to compare data between two tables in db2?
What is bind in db2?
What is cursor stability in db2?
How do you find the maximum value in a column in db2?
What is dpf in db2?
What is the difference between bind and rebind in db2?
What is db2 instance?
Explain in brief how does db2 determine what lock-size to use?
What are the different types of base tables?
How to find schema of a table in db2?
Is db2 free?
Cursors can be declared in both working-storage & procedure division, agreed. But is there any difference? If could you please suggest what is the difference
Can we insert update delete in view?