Answer / Prem Kumar Singh

Reorganization (REORG) in DB2 helps to maintain data integrity, improve storage efficiency, and enhance query performance by adjusting the physical organization of data within a table.

What parameters are used to control the free space in DB2?

1 Answers  

---

what is the responsibility of the construction superintendent

1 Answers   Almco,

---

What is with ur in db2?

1 Answers  

---

What is db2 look?

1 Answers  

---

What is db2 instance?

1 Answers  

---

How can deadlocks be resolved?

1 Answers  

---

What DB2 Catalog column tell you when an index needs table reorganized ?

1 Answers  

---

How to see the structure of db2 table??

4 Answers   IBM,

---

What is deadlock?

2 Answers  

---

What is difference between *omit and *nopass?

1 Answers   IBM, TCS,

---

I am having n number of records in a table which consists of emp-name is one of the field among them. Now i want to change the first letter of every name with capital.

1 Answers   Cap Gemini,

---

Where is the output of EXPLAIN stored?

2 Answers  

---