What is db2 isolation?

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is precompiler in db2?

587


Is db2 a programming language?

606


What is ibm db2 connect?

574


How to access db2 tables in mainframe?

615


What is the connection string to connect to the DB2 Database ?

614






What are types of indexes?

593


How can you validate Sql errors during cursor operation in db2 pgms and where do you code?

1709


How to find the number of rows in db2 tables?

617


What is the maximum size of a char data type in db2?

588


What are the two types of logging in the db2 database? Explain them.

582


What is dpf in db2?

666


What is the use of reorg in db2?

608


How do I import a csv file into db2?

562


Can we delete records from view?

566


How to create backup table in db2?

644