How would one remove old reorg information from the DB2 catalog?

2 Answers  

---

Explain how can you do the explain of a dynamic sql statement?

0 Answers  

---

Define db2 and its databases?

0 Answers  

---

What is the difference between Primary key and unique index?

6 Answers  

---

What is the difference between cursor stability and repeatable read isolation levels?

0 Answers  

---

---

What is reorg and runstats in db2?

0 Answers  

---

What is the meaning of -805 SQL return code?

3 Answers  

---

What is buffer pool?

0 Answers  

---

If a non-DB2 program calls a DB2 program, the calling program's name will be there in SYSIN of IKJEFT01 and the plan name will be that of the called program. But is a bind needed or a plan has to be created for the non-DB2 program also?

1 Answers   RBS,

---

What is the command used by TSO users to invoke DB2?

2 Answers   IBM,

---

Explain the contents that are a part of dclgen.

0 Answers  

---

Hi , I am posting some interview ques . what is the use of cursors ? what is the diff between select and cursor ? bith are used for data retrival .. rite?

2 Answers   Deloitte,

---