Answer / harish

Reorg is needed whenever indexed columns are updated frequently.

When indexed columns are updated frequently, then the index
for the table has to be created again.

So REORG utility is run which will drop the index and create
the index again for the table.

Answer / srini

REORG will reorganise the records as per the clustered
Index/index fields,so that the system can access records
easily thru which the access cost will come down
drastically,so its always advisable to run REORG after
every mass inserts/updates/deletes on table.

Answer / vivekk ram

when ever a record is deleted, it marks the record to be deleted but the physically it is not deleted in db. So using reorg command is ran, it physically deletes the record from db.

Please correct me, if i'm wrong..

What's the maximum number of volumes that can be added to a STOGROUP?

1 Answers   IBM,

---

Why select is not preferred in embedded sql programs?

0 Answers  

---

can we update the table by using cursors can anyone post the query?

5 Answers   DELL, HCL,

---

wht are the restrictions for union ?

2 Answers   CTS,

---

What is ALTER ?

3 Answers  

---

by using cursors , we can access particular records from the table based on some condition, i want to delete those selected records, how can we write a query for this in the program?

4 Answers   Mphasis,

---

What Utility is used to migrate DB2 from one release to the next?

1 Answers  

---

What can the SET option of the Repair Utility accomplish?

1 Answers  

---

What is a clustering index ?

3 Answers  

---

Where is the access path logic created by the DB2 Optimizer stored?

1 Answers  

---

How do you do the EXPLAIN of a dynamic SQL statement?

2 Answers  

---

Hi , I am posting some interview ques . what is the use of cursors ? what is the diff between select and cursor ? bith are used for data retrival .. rite?

2 Answers   Deloitte,

---