Answer / s

CS - page or row locks are released as soon as the cursor
is moved to another row or page.

RR - page or row locks are held for all accessed rows,
qualifying or not atleast until the next commit point.

What is an intent lock?

3 Answers  

---

What does a deadlock mean in DB2?

0 Answers  

---

What is the role of union all and union

0 Answers  

---

how to copy the host variables from ps file into cobol program other than include statement

1 Answers   Syntel,

---

Can you access the DB2 Directory table using SQL?

3 Answers  

---

---

how can we retrieve the 100 records of the file ?

2 Answers   IBM,

---

What is a collection?

3 Answers  

---

What is the physical storage length of date data type?

0 Answers  

---

what are stage one indexable predicates?

1 Answers  

---

How can i install db2 9.x on AIX based system..? plz reply the detailed steps involved....?

0 Answers   IBM, TCS,

---

I have a table(product),It contain fields(productname,cost). I want to retrieve the product name ,which cost is second maximum in the table?

10 Answers   Fidelity,

---

How can you classify the locks in db2?

0 Answers  

---