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.

In terms of DB2 indexing, what is the root page?

1 Answers  

---

Parm value passed is PARM=(10,20). how do code linkage section and how would you add these two passes values and show result in cobol program.

3 Answers   IBM,

---

Where do you specify them?

0 Answers  

---

How to find schema of a table in db2?

0 Answers  

---

in my project..TEST is db2 8.1 version In PROD it is 7.1 if i do REORG in TEST.. can I use the same REORG jcl with out modification in PROD region (this is DB2 8.1 )? if not, what modification i need to do in my REORG control card?

0 Answers  

---

What do you do to keep the cursor from closing after a commit?

1 Answers  

---

Update command

1 Answers  

---

There is a 5000 EMP in company.how we find out the 5th highest getting salary employee outof 5000 employes........

10 Answers   IBM,

---

What is normalization and what are the five normal forms?

1 Answers  

---

How do I create a table MANAGER (EMP-NO, MANAGER) where MANAGER is a foreign key which references to EMP-NO in the same table? Give the exact DDL.

3 Answers  

---

i have table agdet i want first 5 maximum commission which query will you write for this thanks in advance

3 Answers  

---

How do you define a correlated name?

1 Answers  

---