Answer / s

MODIFY RECOVERY utility

Answer / mehdee

The online REORG INDEX or REORG Table Space utility
reorganizes an index space or Table Space to improve access
performance and reclaim fragmented space.
RUNSTATS utility will collect inline statistics and update
DB2 catalog.

What is a db2 schema?

0 Answers  

---

What is cursor stability in db2?

0 Answers  

---

Can we use select * statement in cobol program without giving field names ???

3 Answers   Zensar,

---

I have a table(product),It contain fields(productname,cost). I want to retrieve the product name ,which cost is second maximum in the table?

10 Answers   Fidelity,

---

What is the difference between CS and RR isolation levels?

1 Answers  

---

---

How to handle null values in db2

4 Answers  

---

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

0 Answers  

---

What's The Error Code For Unique Index Voilation?

0 Answers   IBM,

---

Where are plans stored?

2 Answers  

---

What is the difference between oracle and db2?

0 Answers  

---

What is a Database Request Module(DBRM)?

4 Answers  

---

what will be the output of the below given query, if no matching records are found : (a.) 0 (b.) null (c.) error select Avg(salary) from TableA where Deptno = 'insurance'

10 Answers   Amdocs,

---