Answer / Prashant Mishra

REORG and RUNSTATS are two important DB2 maintenance utilities. REORG reorganizes data within a table or index to maintain performance and consistency, while RUNSTATS collects statistics about tables and indexes to help the optimizer make better decisions.

Explain transactions, commits and rollbacks in DB2.

3 Answers  

---

what is the difference between join and union?

4 Answers   IBM,

---

How will you delete duplicate records from a table?

7 Answers   Google,

---

What happens to a tablespace when its recovery infromation has been removed and a full recovery is no longer possible?

2 Answers  

---

What is DCLGEN?

2 Answers  

---

How is a typical DB2 batch program executed ?

1 Answers  

---

What are the functions of Bind?

2 Answers   Amdocs, IBM,

---

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

1 Answers  

---

DB2: A calls B once sucessfull and second time when it calls says curson is open why is it so?

1 Answers   IBM,

---

ther r 2 tables OTTABLE & SALTABLE, add the otamt from OTTABLE to empsal of SALTABLE if eid is matched else add the unmatched from OTTABLE to SALTABLE

1 Answers  

---

What kind of database is db2?

1 Answers  

---

where can we use index and subscript ? with example ?

3 Answers   CTS,

---