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 an alias and how does it differ from a synonym?

3 Answers  

---

Write a query to extract first 5 characters of a name in the column Stud_Name?

1 Answers   RBS,

---

what is consistency token

3 Answers  

---

What is dclgen in db2?

0 Answers  

---

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

0 Answers  

---

what is cursor stability?

2 Answers   IBM,

---

Explain about open switch business continuity software?

0 Answers  

---

I have a DB2 table which has 1000 rows.after udatingg first 110 rows, my job abends. Now what I have to do if I want to restart the job next time so that it should start updating from 111th row (without updating first 110 rows again).

10 Answers   Cap Gemini, Wipro,

---

what happend with out using Commit,when closing cursor and program?

5 Answers   CSC,

---

what are the copybook changes generally we done?can anyone tell me......... Thanks in advance........

1 Answers  

---

How to resolve -504 sql code in DB2?

2 Answers   Cap Gemini,

---

What is the COBOL picture clause for a DB2 column defined as DECIMAL(11,2)?

5 Answers   Emsang,

---