Explain what are the various isolation levels possible?
- 1 Answers
- 1123 Views
- I also Faced
- E-Mail Answers
Answer / Shobha Yadav
Isolation levels in DB2 determine how transactions interact with each other and the database. There are several levels, including:nn- SERIALIZABLE: Each transaction appears to execute serially, one after another. No interference between transactions is allowed.n- REPEATABLE READ: Transactions cannot see changes made by other transactions that began after the transaction started.n- READ COMMITTED: A transaction can see changes committed by other transactions before it starts, but not changes that are still in progress.n- UNCOMMITTED: This level allows dirty reads (reading uncommitted data), nonrepeatable reads (changes made to a row by one transaction may be overwritten by another transaction), and phantom reads (new rows added by another transaction may appear or disappear).
| Is This Answer Correct ? | 0 Yes | 0 No |
define clustering index.
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
What is reorg and runstats in db2?
db2 maintains information about the data... a.in tables. b.in a set of tables known as db2 catalog. c.in db2 database. d.none of the above.
What is cobol db2?
How can the duplicate values be eliminated from db2 select?
How to select the duplicate rows from a table?
can i code union in cobol-db2 pgm ?
what types of copies can be made with the COPY Utility ?
How do I add a column to an existing table in db2?
pls tell me abt the normalization five types....
I need to view the number of tables existing under one particular Owner. Is it possible? If so, pl give the SQL query for this?
COBOL 
