What is db2 isolation?
Answers were Sorted based on User's Feedback
Answer / mohammadanis
DB2 Isolation is locking technqiue for tables.It can given
while binding the programs. There are several Isolation
levels are there,
1 CS(cursor stability)
2 RR(repeatable read)
3 RS(READ Stability)
4 UR(Uncommited read also known as Dirty read
Is This Answer Correct ? | 10 Yes | 2 No |
Answer / bala
Isolation by its name explains the level by which two or more concurrent transactions are isolated from each other to maintain the data integrity in the database.
for example transaction A and transaction B are concurrent transactions, then it defines if A can read/update the data being modified by B or not and vice versa.
These Isolation levels will be used based on the business logic.
Is This Answer Correct ? | 2 Yes | 0 No |
How are write I/Os from the buffer pool executed?
How do you eliminate duplicate values in db2?
Define predicate?
What is the difference between nvl and coalesce?
what is dynamic cursor?gives syntax for this?
How many buffer pools are there in DB2?
I am getting a error multiple row fetched while executing a Cobol-DB2 program.How can I solve it without using a cursor.
Explain the contention situations caused by locks?
How to resolve SQL Code -310. The db table feild is declared as Decimal(7,2).
How to get Top 10 Salaries from a Table
What is a correlated sub query?
where can we use index and subscript ? with example ?