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

what is the certification that has a good value for a practioner in mainframes but not habving much knowledge on db2 related stuff?

2 Answers  

---

Why might full image copies be faster to implement than an incremental image copy?

4 Answers  

---

What is a view? Why use it?

3 Answers  

---

Explain about rct in db2?

0 Answers  

---

DB2 can implement a join in three ways using a merge join, a nested join or a hybrid join. Explain the differences?

0 Answers  

---

my project is insurance management system,how to explain my work environment in interview?

2 Answers   CGI, Value Labs,

---

What if , we failed to mentioed null indicator in sql select query , that may retrieve null value ?

2 Answers   Cap Gemini,

---

Comment whether dclgen is mandatorily used. If not, then what is the point of using it?

0 Answers  

---

How and when does the db2 enforces the unique key?

0 Answers  

---

in db2, already 10 columns arie der, and i want to insert 11th column. what parameters u wil consider for insertion and how will u insert

1 Answers   TCS,

---

What do the initials DDL and DML stand for and what is their meaning?

2 Answers  

---

What is a thread?

3 Answers  

---