Interested to Buy Any Domain ? << Click Here >> for more details...
What is db2 isolation?
- 2 Answers
- 7379 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 |
5 rows are inserted to a DB2 Table. Next 3 of those are updated, then a rollback is issued. What would happen when the rollback is issued?
What is the logical entity between plan and Package?
Name the various locking levels available?
Can DASD types assigned to storage groups be intermixed (i.e., 3350s and 3380s)?
what is contained in the DB2 node lock file? A) data base names B) data base users names C) license keys D) server names
What is db2 connect?
What is DCLGEN?
What are iseries servers?
How many sub queries can you combine together ?
What is table space in db2?
before altering a table is it necessary to lock ? if lock what is it ? how to do ? ifi want to lock a table what is that command ?
How do you retrieve the first 5 characters of firstname column of db2 table emp?
COBOL 
