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 temporal table in db2?

0 Answers  

---

In SPUFI suppose you want to select maximum of 1000 rows, but the select returns only 200 rows. What are the 2 SQLCODEs that are returned?

1 Answers  

---

cursor with hold explain ?

1 Answers   Verizon,

---

how to resolve -805. give clear explination for that

2 Answers   IBM,

---

What are the various isolation levels possible?

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 is the role of the data page in the db2 database?

0 Answers  

---

1. what if null values retrived from database and no null indicator mentioned in query. What is sql code.

1 Answers   Cap Gemini,

---

How does DB2 use multiple table indexes?

1 Answers  

---

How does DB2 store NULL physically?

2 Answers  

---

Explain correlated sub-queries.

0 Answers  

---

what are the bind parameters?

5 Answers   IBM,

---