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 is a base table?

2 Answers  

---

What is the size of a data page?

2 Answers   IBM,

---

Define db2.

1 Answers  

---

Can we use group-by clause in sub-query? If 'yes' means,Will it be executed successfully or else If 'no' means why should we not using that method? Give me your suggestion please....

1 Answers  

---

How can you split a table in to exactly half?

7 Answers   HSBC,

---

What is declare cursor?

1 Answers  

---

Suppose there are many duplicate records in a Db2 table. What is the query to retrive only duplicate records?

4 Answers  

---

What is the latest version of ibm db2?

0 Answers  

---

Is db2 a mainframe?

1 Answers  

---

What is the use of reorg in db2?

1 Answers  

---

in my project..TEST is db2 8.1 version In PROD it is 7.1 if i do REORG in TEST.. can I use the same REORG jcl with out modification in PROD region (this is DB2 8.1 )? if not, what modification i need to do in my REORG control card?

1 Answers  

---

What is copy book?

1 Answers   Thomson Reuters,

---