Answer / s

Writes are queued until a commit, checkpoint happens. Also
when write thresholds are exceeded, stop database, stop db2.

What is a Cartesian product?

2 Answers  

---

What is the use of with ur in db2?

0 Answers  

---

Differentiate between cs and rr isolation levels? Where do you specify them?

0 Answers  

---

what's the equivalent Cobol Data type for Decimal(x,y) in DB2? what does the current SQLID register contain?

3 Answers   Cap Gemini, Tech Mahindra,

---

What is the difference between using bind () and rebind () methods of naming class?

0 Answers  

---

I need to view the number of tables existing under one particular Owner. Is it possible? If so, pl give the SQL query for this?

3 Answers  

---

What is lock escalation in db2?

0 Answers  

---

how to get duplicate records from tables?write qurey for this?

4 Answers   ANZ,

---

Can DASD types assigned to storage groups be intermixed (i.e., 3350s and 3380s)?

1 Answers  

---

Suppose we are doing transaction in a table and abend happened in between. Suppose i have completed the transaction upto X rows and I want to start the transaction again where the abend happened. I don't want to do the transaction from the first record. Then what i have to do.

9 Answers   Cap Gemini,

---

What are the four lockable units for DB2?

1 Answers  

---

wht are the restrictions for union ?

2 Answers   CTS,

---