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..

Update command

1 Answers  

---

How can deadlocks be resolved?

0 Answers  

---

Define buffer pool.

0 Answers  

---

how to fetch first 100 rows in db2

2 Answers   IBM,

---

What are the different methods of accessing db2 from tso? How is the connection established between TSO & DB2?

3 Answers   Tech Mahindra,

---

What is cascading rollback?

0 Answers  

---

Explain an outer join?

1 Answers  

---

When can an insert of a new primary key value threaten referential integrity?

2 Answers   Mind Tree,

---

what is the difference between declaring the cursor in WS section and Procedure division?

1 Answers   HCL,

---

What is a view? Why use it?

3 Answers  

---

What is FREEPAGE and PCTFREE in TABLESPACE creation?

1 Answers  

---

What does this mean ? GRANT BIND,EXECUTE ON PLAN MK2 TO PUBLIC;

4 Answers   Accenture,

---