Answer / vasuki🐍

reorganizes the table and its indexes by
rebuilding the index data into unfragmented and contiguous area on the disk.
Normally after a large amount of INSERT, UPDATE, DELETE activities on data tables, we generally need a REORG.
After a table space reorganization the fragments are moved around and clustered,
however the database still utilizes the old statistic to query the data.
So it is recommended to run a RUNSTATS on the table.
This command updates the statistic information.
Besides it makes sure that the DB2 optimizer takes advantage of the refreshed statistic information.

Reorg>>runstats

How could one combine a set of incremental image copies into a single copy?

1 Answers  

---

What is db2 look?

0 Answers  

---

Can you use a select query in a loop to fetch multiple rows? If so what is the advantage of using a cursor?

2 Answers   L&T, UST,

---

What is the difference between dbm cfg and db cfg file in db2 ?

0 Answers   MCN Solutions,

---

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

1 Answers   Fidelity,

---

Cursors can be declared in both working-storage & procedure division, Agreed. But is there any difference? If could you please suggest what is the difference. TIA

8 Answers   CGI, Wipro,

---

Who uses db2?

0 Answers  

---

What are some SQL aggregates and other built-in functions?

2 Answers  

---

What is a DBRM, PLAN ?

3 Answers  

---

What is with ur in db2?

0 Answers  

---

What is dclgen (declaration generator)?

0 Answers  

---

What are the four lockable units for DB2?

1 Answers  

---