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

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.

How to fetch the uncommited data from table ?

1 Answers   JPMorgan Chase,

---

What is a dbrm in db2?

0 Answers  

---

On the create tablespace, what does the CLOSE parameter do?

1 Answers  

---

How will you delete duplicate records from a table?

7 Answers   Google,

---

What is explain in db2?

0 Answers  

---

What is ACQUIRE/RELEASE in BIND?

3 Answers   Cognizant,

---

Is db2 a mainframe?

0 Answers  

---

what is different three logs in DB2?

1 Answers   Syntel,

---

db2 restart logic ?

1 Answers   DELL, HTC, UHG,

---

OUTER JOINS USED TO GET MATCHING AND NONMATCHING ROWS FORM 2 OR MORE TABLES BASED ON COLUMNS. SIMPLE JOINS ALSO DO THE SAME THEN WHAT IS THE USE OF OUTER JOINS.

1 Answers   Syntel,

---

i have cobol+ db2 program but it contains n number of subprograms for this how many dbrm members i need to mention in bind process

2 Answers  

---

What can the Locate option of the Repair Utility accomplish?

2 Answers  

---