What will the FREE command do to a plan?

2 Answers  

---

What is innodb buffer pool?

0 Answers  

---

pls explain the precompilation process of cobol-db2 pgm

3 Answers   HCL, IBM,

---

I use CS and update a page. Will the lock be released after I am done with that page?

2 Answers  

---

suppose in my table 10 rows are there , i want to update odd rows salary as 90000 ? how u do it ? any one help me ? what do we use here cursor-fetch or normal sql ?

5 Answers   IBM,

---

---

What is an EXPLAIN in DB2. How and what is the steps followed in EXPLAIN command. Can all the queries be used in EXPLAIN command to check the performance.

3 Answers   IBM,

---

How are write I/Os from the buffer pool executed?

1 Answers  

---

What is isolation level?

4 Answers  

---

I understand Join always perform better than subqueries. Then what is the advantage/use of Subqueries/correlated subqueries etc.,in DB2 programming.Please explain.

0 Answers  

---

When DB2 connection fails, will online program work or give errors.

1 Answers   Virtusa,

---

While unloading huge amount of data from table. Suddenly job failed some error. Imagine 1M data unloading, In that 90% data unloaded only 10% left, So if want to unload the rest 10% what needs to be done? Whether do i need to start from top or anything ?

0 Answers   JPMorgan Chase,

---

query to just fetch first matching row and stop execution. once one matching row is found ..no more records should be checked.. if the first record is matching.. the query must stop

2 Answers   IBM,

---