Interested to Buy Any Domain ? << Click Here >> for more details...
What is db2 isolation?
- 2 Answers
- 7229 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 |
why we go for SPUFI for creating tables or for sql queries?
Explain how can you do the explain of a dynamic sql statement?
What is a SELECT statement?
What can the Locate option of the Repair Utility accomplish?
Define db2.
What is the function of the Data Manager?
db2 restart logic ?
Explain in brief how does db2 determine what lock-size to use?
What is tablespace?
What is iseries database?
How can we define a table? How can we apply SEARCH ALL on it ?
Give the COBOL definition of a VARCHAR field.
COBOL 
