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 ibm db2 database?
can any one provide me the link for the db2 v7 & db2 v8 manual for Z/os? i need to know about the syntax of REORG in both versions & need to know the difference as well
What are host variables in db2?
When a COBOL-DB2 program in PRODUCTION is updating main tables and gone for long run, what have to do?
What is multi row fetch in db2?
Is db2 a database?
How to resolve deadlock issue
How to find the maximum value in a column in the db2 database?
Describe major components of db2?
In an sql table that is embedded, what is the procedure to retrieve rows that are part of a db2 table?
What is copy pending status in db2?
What is the reason behind not using select * in embedded sql programs?
What are db2 objects?
Explain dclgen.
What is iseries database?
