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 |
which is the most efficient tablespace?? a.simple tablespace. b.partitioned tablespace. c.segmented tablespace. d.none of the above. please post answer with the reason.?
What is the SQL query to select, delete and get count of duplicate rows in DB2?
What is ibm db2 database?
How do you pull up a query which was previously saved in qmf?
what are the copybook changes generally we done?can anyone tell me......... Thanks in advance........
What is difference between *omit and *nopass?
What is Reorg Recovery? when will you run it?
what is the difference between normal select query and currosor
What is the difference between using bind () and rebind () methods of naming class?
What is meant by dclgen?
How would one remove old reorg information from the DB2 catalog?
What is meant by union and union all?