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
Explain the benefits you can get from mainframe connect?
What os does db2 run on?
Is the primary key a clustered index?
What is page size in db2?
Hi Everyone... Under the Logical files, when am working on multiple rec format logical file, I have joined two pf's using the multiple record format logical file concept, but when i run queried the LF only the first mentioned pf records are reflecting and I am not able to see any of the field records specified under the second pf. Kindly let me know whats the reason behind this. Below is the str of LF., R rec PFILE(LOGICAA) CUSTNO CUSTNAME BILL K CUSTNO R rec1 PFILE(LOGICAA1) CUSTNO ADD K CUSTNO .....
How and when does the db2 enforces the unique key?
What action db2 takes when a program aborts in the middle of a transaction?
I have a subprogram B calling from mainprogram A.I have opened a cursor in A ,Can i fetch the same cursor in subprogram B , If yes , Please explain the reason?
What is a plan and package in db2?
What does db2 stand for?
Explain about rct.
How can record locking be achieved in those DB2 versions which do not support it?
What is the use of value function?
List down the data types in the db2 database.
What is bind plan?