Interested to Buy Any Domain ? << Click Here >> for more details...
What is db2 isolation?
- 2 Answers
- 7375 Views
- I also Faced
- E-Mail Answers
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 |
difference between group clause and order clause
What is isolation level?
What are common abends
When is the results table for the query in a DECLARE CURSOR statement created?
What error I will get if my select query gives multiple row while executing a Cobol-DB2 program.How can I solve it without using a cursor.
4 Answers Cap Gemini, Verizon,
What is a DB2 plan?
What db2 400?
What are the various locking levels available?
What is alias in db2?
What do you need to do before you do EXPLAIN?
What is declare cursor?
What do the initials DDL and DML stand for and what is their meaning?
COBOL 
