Interested to Buy Any Domain ? << Click Here >> for more details...
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
What is runstats db2?
What is the difference between dbm cfg and db cfg file in db2 ?
How can you count the number of rows from a table tab?
What is runstats and reorg in db2?
What is difference between isnull and coalesce?
What is ibm db2 database?
What is an instance in db2?
what is diffrence b/w file-aid tool and file-aid utility???
How would the varchar column remarks defined?
What is dbrm? What it contains?
What is reorg and runstats in db2?
How do I delete a column in db2?
Why select is not preferred in embedded sql programs?
What is dbrm?
What is a db2 package?
