Answer / s

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

What is schema in db2?

0 Answers  

---

what is the difference between normal select query and currosor

2 Answers   Cap Gemini, TCS,

---

What is meant by repeatable read?

4 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 is a DB2 plan?

8 Answers  

---

How to resolve the -305 error code in DB2? And also please let me know, how to resolve the db2 error codes.

7 Answers   TCS,

---

What is the physical storage length of timestamp data type?

0 Answers  

---

Lot of updates have been done on a table due to which indexes have gone haywire. What do you do?

2 Answers  

---

What can the Locate option of the Repair Utility accomplish?

2 Answers  

---

how can we retrieve the 100 records of the file ?

2 Answers   IBM,

---

wht are the restrictions for union ?

2 Answers   CTS,

---

What is a Resource Control Table(RCT)? Describe its characteristics.

3 Answers  

---