Answer / s

RUNSTATS is run when there is heavy insert/update activity
that changes the characteristics of the data to a great
extent. Follow REORG with RUNSTATS. Usually after REORG to
record the organized data so that optimizer chooses a
better access path.

What are host variables in db2?

0 Answers  

---

How do I delete a table in db2?

0 Answers  

---

What is the purpose of the WHENEVER statement?

1 Answers  

---

How do you prepare a COBOL + DB2 program from coading till execution ?

1 Answers   Amdocs, Xansa,

---

What is query for your birthday date should be in hours,minute and seconds format?

1 Answers   Fidelity,

---

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

0 Answers  

---

wht happens if we close cursor with cursor with hold option?

3 Answers   Valtech,

---

What is meant by index cardinality?

2 Answers  

---

PLAN IS EXECUTABLE AND PACKAGE IS NOT EXECUTABLE . THEN WHAT IS THE USE OF PACKAGE?

2 Answers   Tech Mahindra, Wipro,

---

What is a DB2 bind?

1 Answers   Logica CMG,

---

List down the types of triggers in the db2 database?

0 Answers  

---

What information is used as input to the bind process?

2 Answers  

---