What is reorg in DB2

Answers were Sorted based on User's Feedback



What is reorg in DB2 ..

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.

Is This Answer Correct ?    36 Yes 5 No

What is reorg in DB2 ..

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.

Is This Answer Correct ?    30 Yes 9 No

What is reorg in DB2 ..

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

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More DB2 Interview Questions

What does the sqlcode of -818 pertain to?

3 Answers  


What is meant by explain?

0 Answers  


What does db2 plan contain?

0 Answers  


how to execute qcmdexc in rpgle?plz write code also?

1 Answers   IBM,


Explain the contention situations caused by locks?

0 Answers  






What is SPUFI?

4 Answers  


What techniques will be used to avoid deadlock??

5 Answers   IBM, SUN,


how can i pull up a query which was previously stored in qmf

3 Answers  


assume ther are 5000 records in a database and want to fetch using cursor. cursor fetches only 3000 records and fetch is not happening for remaining 2000 records. why it happens and how to rectify it

1 Answers   TCS,


What is reorg and runstats in db2?

0 Answers  


Define db2 and its databases?

0 Answers  


Explain about rct in db2?

0 Answers  


Categories