Interested to Buy Any Domain ? << Click Here >> for more details...
What is db2 isolation?
- 2 Answers
- 7310 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 |
What is the physical storage length of the data types: date, time, timestamp in the db2 database?
How is the value function used?
What is the use of COMMAREA ?Minimum how much data we can pass from it?
Explain the benefits you can get from mainframe connect?
What is the information associated with sysibm.syslinks table?
I have a table name Table1 which contain columns Cust_no, car_model, country, salesamt. The records are 101, Fiat, India, 12345 2nd record is 102, Tata, USA, 98743 3rd record is 101, indica, India, 65342 4th record is 103, Toyota, UK, 64522 5th record is 103, Maruti, USA, 98632 and so on..... Now my question is write sql query which will give me detail about the sum of sales amount in perticular country
What is COPY PENDING status?
How we create a tables in db2,what is the process/syntax to create a table with example plz?
What is the maximum size of a char data type in db2?
What is ibm db2 database?
Compare a subselect to a join?
How is a typical db2 batch pgm executed?
COBOL 
